>why not have server a start at 1 and server b start at max int8/2. that will give each server alot of orders before
>you have an issue. They will will not have to play games with the sequence value.
>
>Jim
>
>
Hi,
Your method is different from mine, but I think that both methods will
face the same constraints in case of failover...
Anyway, my setup is working fine, so I won't change anything !
The only point is that it could have been useful to be able to lock a
sequence...
It seems that it was possible with PostgreSQL 7.0, but was removed in 7.1 :
http://archives.postgresql.org/pgsql-hackers/2001-10/msg00928.php
Best regards,
Philippe Ferreira.