-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Le 07/07/2010 09:35, raghu ram a écrit :
> 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.

Hi,

First of all, I'd suggest you upgrade to the latest version of Slony in the 1.2
branch. It does not require any downtime, and will let you use a version that
has been cleared of known bugs.

Concerning the id of your table, is there any table with this idea in your
replication schema ? Are your sure all your tables and sequences have the same
id in all your nodes ?
What's more, what does the sl_status view report ?

Best regards,
- -- 
Stéphane Schildknecht
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkw1o7MACgkQA+REPKWGI0GGYQCfQW79A5fJRrEEfUpjUvxzfj5d
jicAn0qGv+Xzk06a+hPY+6eLpbq7PYt0
=ijrA
-----END PGP SIGNATURE-----