Hi All,

below is my assumption regarding failover, so please correct me if I'm
wrong -

-------------------------------------------------------------------------------
a table T is created with primary key K (sequence), Slony is configured
to replicate both table T and primary key K. When a failover is made,
there could be a short instance where new row(s) are inserted  and
replicated to the slave, but the sequence's last value is still not
updated at the slave. As such, subsequent inserts would fail with
duplicate key error until the slave's value is adjusted, manually or
otherwise.
-------------------------------------------------------------------------------

If the above situation should occur, what can done to
prevent/eliminate/avoid it?

Regards
Andrew
-- 
  Andrew Ng
  ngandrew at fastmail.fm

-- 
http://www.fastmail.fm - A fast, anti-spam email service.