On Mon, Aug 10, 2009 at 3:56 PM, Sweta Mulgavker
<sweta.mulgavker at gmail.com>wrote:

>
>
> ERROR -->
>
>   replconfig.cnf:85: PGRES_FATAL_ERROR select "_replcluster".setAddTable(=
8,
> 36, 'public.t_i_shift_shadow', 't_i_shift_shadow_pkey', 'shift shadow
> table');  - ERROR:  duplicate key violates unique constraint
> "sl_table_tab_reloid_key"
>
> CONTEXT:  SQL statement "insert into "_replcluster".sl_table (tab_id,
> tab_reloid, tab_relname, tab_nspname, tab_set, tab_idxname, tab_altered,
> tab_comment) values ( $1 ,  $2 ,  $3 ,  $4 ,  $5 ,  $6 , false,  $7 )"
>
> PL/pgSQL function "setaddtable_int" line 103 at SQL statement
> SQL statement "SELECT  "_replcluster".setAddTable_int( $1 ,  $2 ,  $3 ,  =
$4
> ,  $5 )"
> PL/pgSQL function "setaddtable" line 37 at perform
>


Can you please show the output for:

select * from _repcluster.sl_table where tab_reloid =3D (select oid from
pg_class where relname =3D 't_i_shift_shadow')


-- =

Shoaib Mir
http://shoaibmir.wordpress.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090810/=
bd6bc28b/attachment.htm