When connecting through pgpool, the query:
UPDATE table SET field1='something' WHERE field2='something_else';
throws the following error:
ERROR: pgpool detected difference of the number of INSERTS, DELETES, or
UPDATES ...(etc. I can't recall the rest of the error message, but I
know it
That error usually appears when there's a difference between backends.
You should compare the number of affected rows on each backend. If the
query you are running is:
UPDATE table SET field1=’something’ WHERE field2=’something_else’;
then you should run:
SELECT COUNT(*) FROM table WHERE fie