[pgpool-committers: 1037] 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
------
master

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

Modified Files
--------------
pool_memqcache.c |    2 +-
1 file changed, 1 insertion(+), 1 deletion(-)



More information about the pgpool-committers mailing list