Hmmm, I don't believe I am replicating my sequences... Could you advise
me where I could read up on this?

Thanks,
Thomas

-----Original Message-----
From: Hannu Krosing [mailto:hannu at skype.net] 
Sent: Friday, May 13, 2005 11:04 AM
To: Thomas Go
Cc: slony1-general at gborg.postgresql.org
Subject: Re: [Slony1-general] Duplicate Key violation question...


On R, 2005-05-13 at 10:44 -0400, Thomas Go wrote:
> 
> I thought I had set this up properly when I created the cluster...but 
> I'm getting the following mesg.
> 
> dns_data=# INSERT INTO domains (name, type) VALUES ('5th.kz', 
> 'NATIVE');
> ERROR:  duplicate key violates unique constraint "domains_pkey"
> 
> We have 2 table something call dom and rec.  I have set this under the

> create set
> 
>         create set (id=1, origin=1, comment=''); 
>         set add table (set id=1, origin=1, id=1, fully qualified name 
> = 'public.dom', comment='domain table');
>         set add table (set id=1, origin=1, id=2, fully qualified name 
> = 'public.rec', comment='records table');
> 
> But I'm still getting the key violates.  I would insert it a few time 
> and then it'll go through.  Any thoughts?

Did you replicate your sequences ?

It looks like you have switced over to slave without actually
replicating the sequences for your tables PK. And then the PK insert
succeeds only when you hit a deleted PK space.

-- 
Hannu Krosing <hannu at skype.net>