On Friday 13 May 2005 08:09, Thomas Go wrote:
> Hmmm, I don't believe I am replicating my sequences... Could you advise
> me where I could read up on this?

SET ADD SEQUENCE

Documentation can be found at:
http://www.dbitech.ca/slony/book/stmtsetaddsequence.html

>
> 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.

-- 
Darcy Buskermolen
Wavefire Technologies Corp.

http://www.wavefire.com
ph: 250.717.0200
fx: 250.763.1759