On Mon, Aug 10, 2009 at 3:56 PM, Sweta Mulgavker
<[email protected]>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 = (select oid from
pg_class where relname = 't_i_shift_shadow')


-- 
Shoaib Mir
http://shoaibmir.wordpress.com/
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to