On R, 2005-05-13 at 11:09 -0400, Thomas Go wrote:
> Hmmm, I don't believe I am replicating my sequences... Could you advise
> me where I could read up on this?

sequences need to be replicated explicitly, replicating a table with a
SERIAL column or DEFAULT nextval('seqname') dos not replicate a sequence

The commant to do so is similar to SET ADD TABLE see:

http://gborg.postgresql.org/project/slony1/genpage.php?
slonik_commands#stmt_set_add_sequence


Note to Slony docs maintainers - I guess the basic howto (
http://gborg.postgresql.org/project/slony1/genpage.php?howto_basic
) should also replicate at least one sequence.


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