| From: | "Talvinder Matharu" <talvinder(dot)matharu(at)ingenta(dot)com> |
|---|---|
| To: | <pgadmin-support(at)postgresql(dot)org> |
| Subject: | postgres replication with sequences |
| Date: | 2005-02-14 13:41:22 |
| Message-ID: | BOEOJAIGPHEHHCGGIBFCIEPKDFAA.talvinder.matharu@ingenta.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vegard Pettersen | 2005-02-14 15:20:23 | Black is beautifull |
| Previous Message | Laramie Crocker | 2005-02-12 18:46:22 | pgAdmin III won't connect over ssh tunnel |