[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