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

Tatsuo Ishii ishii at postgresql.org
Sat Mar 31 10:00:50 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
------
V3_1_STABLE

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

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