[pgpool-committers: 1036] pgpool: Fix bug #58, fails to invalidate query cache.
Tatsuo Ishii
ishii at postgresql.org
Wed Jun 12 19:26:47 JST 2013
Fix bug #58, fails to invalidate query cache.
CREATE TABLE t1(i INTEGER);
CREATE TABLE t2(i INTEGER);
SELECT * FROM t1;
BEGIN;
DELETE FROM t2 WHERE i = 0;
INSERT INTO t1(i) VALUES(1);
COMMIT;
SELECT * FROM t1;
At commit pgpool tries to delete cache for t2 but failes because
there's no oid table entry for t2. Problem is, it fails to check oid
table for t1. So cahce for t1 remains and the last SELECT incorrectly
returns cached data. Fix is, continuing to check oid table entries.
Branch
------
V3_2_STABLE
Details
-------
http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=a6d91284223576d82f9eef689493c883d1efcc69
Modified Files
--------------
pool_memqcache.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
More information about the pgpool-committers
mailing list