raghu ram wrote:
> 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::
> 
>  
> 

Is it possible that you did a 'DROP TABLE' of a replicated table without 
first removing the table from slony ('set drop table')

Also 1.2.11 is fairly out of date, the 1.2 stream is up to 1.2.21.  You 
should familiarize yourself with the issues that have been addressed 
since then.


> 
> <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
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general


-- 
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142