Is it possible that you have the table defined twice in your build
script?
Or if you are trying to add this table to an existing replication set,
perhaps it is already added? Run the following query to find out:
"select * from _repcluster.sl_table where relname = 't_i_shift_shadow';"
--Richard
On Aug 9, 2009, at 10:56 PM, Sweta Mulgavker wrote:
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.
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
