[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