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>