Sun Aug 9 22:56:07 PDT 2009
- Previous message: [Slony1-general] Slony scripts
- Next message: [Slony1-general] duplicate key violates unique constraint
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hello all, I have a table named "t_i_shift_shadow" with following spec Column | Type | Modifiers -----------------+-----------------------+---------------------------------= ---------------------------------- cid | character varying(20) | not null shift_rev_id | character varying(20) | not null start_time | bigint | not null end_time | bigint | not null lunch_from_time | bigint | default -1 lunch_to_time | bigint | default -1 shift_date | date | not null is_cyclic | integer | not null serial | integer | not null default nextval('t_i_shift_shadow_serial_seq'::regclass) Indexes: "t_i_shift_shadow_pkey" PRIMARY KEY, btree (serial) Triggers: _replcluster_logtrigger_4 AFTER INSERT OR DELETE OR UPDATE ON t_i_shift_shadow FOR EACH ROW EXECUTE PROCEDURE _replcluster.logtrigger('_replcluster', '4', 'vvvvvvvvk') I am trying to replicate this table using slony. But I get the following error... 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 somebody please help me out :( Thanks and Regards, Sweta. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090810/= a82a015d/attachment.htm
- Previous message: [Slony1-general] Slony scripts
- Next message: [Slony1-general] duplicate key violates unique constraint
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list