[pgpool-committers: 95] pgpool: Allow to use multi statement in master/slave mode. From 3.1

Tatsuo Ishii ishii at postgresql.org
Sat Mar 31 10:03:52 JST 2012


Allow to use multi statement in master/slave mode. From 3.1
transactional statements such as "BEGIN" are sent to not only primary
but also standbys. This brings an unfortunate side effect: if the
multi statement is "BEGIN;DELETE FROM table;END", this will be sent to
standy as well and cause an error because standby does not allow write
SQL. So fix is, if a query is a multi statement one, then send it to
primary only.

Committed to master and V3_1_STABLE.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=1ea486c29e8f3ff5d9b1ae69f32e2dde56bc0302

Modified Files
--------------
pool_proto_modules.c |   12 ++++++++++++
pool_query_context.c |   21 +++++++++++++++++++++
pool_query_context.h |    1 +
3 files changed, 34 insertions(+), 0 deletions(-)



More information about the pgpool-committers mailing list