Mon Aug 10 01:54:07 PDT 2009
- Previous message: [Slony1-general] duplicate key violates unique constraint
- Next message: [Slony1-general] install altperl scripts
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Mon, Aug 10, 2009 at 5:08 PM, Sweta Mulgavker <sweta.mulgavker at gmail.com>wrote: > > > > cars=3D# select * from _replcluster.sl_table where tab_reloid =3D (select= oid > from pg_class where relname =3D 't_i_shift_shadow'); > > > tab_id | tab_reloid | tab_relname | tab_nspname | tab_set | > tab_idxname | tab_altered | tab_comment > > --------+------------+------------------+-------------+---------+--------= ---------------+-------------+-------------------- > 4 | 67006 | t_i_shift_shadow | public | 1 | > t_i_shift_shadow_pkey | t | shift shadow table > (1 row) > This means the table is already added to the Slony cluster, you need to first drop it out of the cluster and then re-add it again. -- = Shoaib Mir http://shoaibmir.wordpress.com/ -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090810/= 61659d63/attachment.htm
- Previous message: [Slony1-general] duplicate key violates unique constraint
- Next message: [Slony1-general] install altperl scripts
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list