[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