[pgpool-committers: 890] pgpool: Fix bug with on memory query cache in handling UPDATE/DELETE wi

Tatsuo Ishii ishii at postgresql.org
Fri Apr 19 14:49:25 JST 2013


Fix bug with on memory query cache in handling UPDATE/DELETE with table alias.

If UPDATE/DELETE is with table alias (UPDATE t1 AS foo...) pgpool
thinks the table name is "t1 AS foo" and fails to invalidate query
cache. This is caused by _outRangeVar() called from nodeToString()
which generates a query string from RangeVar node in raw parse
tree. The solution is removing "AS foo" part from the output of the
string. But reported in bugtrack #56.

Branch
------
V3_2_STABLE

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

Modified Files
--------------
pool_memqcache.c |   36 ++++++++++++++++++++++++++++++++++--
1 files changed, 34 insertions(+), 2 deletions(-)



More information about the pgpool-committers mailing list