Hi,
I have noticed that there is a bug with replicating sequences using
DBMirror.pl. In the method sendQueryToSlaves there is a test for
PGRES_COMMAND_OK, which applies to INSERTS/UPDATES. However, when trying to
update the sequence, you set the value by using a select "SELECT setval..."
and so the value set does not equal to PGRES_COMMAND_OK but should be tested
against PGRES_TUPLES_OK. If you fail to do this test then sequences will
fail to be removed from the pending list within the database and as a result
there will be a queue.
Hope this is useful info.
Cheers,
Talvinder
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
