raghu ram raghuchennuru at gmail.com
Wed Jul 7 00:35:51 PDT 2010
Hi,


We setup the Slony replication b/w master and salve. We are trying to drop a
column of the replication table.


We are facing the errors, while executing the execute script to drop a
column::




<stdin>:6: PGRES_FATAL_ERROR select "_testreplica".ddlScript_prepare(1, -1);
- ERROR: Slony-I: alterTableRestore(): Table with id 206 not found

CONTEXT: SQL statement "SELECT "_testreplica".alterTableRestore(tab_id) from
"_testreplica".sl_table where tab_set in (select set_id from
"_testreplica".sl_set where set_origin =
"_testreplica".getLocalNodeId('_testreplica'))"

PL/pgSQL function "ddlscript_prepare" line 34 at perform


Here,slonik_execute_script referring table id is 206 but where as my table
id is different in slony schema. i.e 139 and also we tried for another
tables, getting the same error.


Slony version:: 1.2.11


Could you please provide suggestions on this issue.


Regards

Raghu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100707/37816006/attachment.htm 


More information about the Slony1-general mailing list