*** ./expected/triggers.out Sat Nov 23 13:13:22 2002 --- ./results/triggers.out Fri Mar 7 15:48:41 2003 *************** *** 88,93 **** --- 88,94 ---- NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted DROP TABLE pkeys; DROP TABLE fkeys; + ERROR: DeleteRelationTuple: cache lookup failed for relation 122479 DROP TABLE fkeys2; -- -- I've disabled the funny_dup17 test because the new semantics -- -- of AFTER ROW triggers, which get now fired at the end of a ====================================================================== *** ./expected/inherit.out Thu Mar 6 00:47:52 2003 --- ./results/inherit.out Fri Mar 7 15:48:41 2003 *************** *** 26,31 **** --- 26,32 ---- INSERT INTO c(aa) VALUES('ccccccc'); INSERT INTO c(aa) VALUES('cccccccc'); INSERT INTO d(aa) VALUES('ddd'); + ERROR: Relation 125442 does not exist INSERT INTO d(aa) VALUES('dddd'); INSERT INTO d(aa) VALUES('ddddd'); INSERT INTO d(aa) VALUES('dddddd'); *************** *** 52,64 **** c | cccccc c | ccccccc c | cccccccc - d | ddd d | dddd d | ddddd d | dddddd d | ddddddd d | dddddddd ! (24 rows) SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid; relname | aa | bb --- 53,64 ---- c | cccccc c | ccccccc c | cccccccc d | dddd d | ddddd d | dddddd d | ddddddd d | dddddddd ! (23 rows) SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid; relname | aa | bb *************** *** 69,81 **** b | bbbbbb | b | bbbbbbb | b | bbbbbbbb | - d | ddd | d | dddd | d | ddddd | d | dddddd | d | ddddddd | d | dddddddd | ! (12 rows) SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid; relname | aa | cc --- 69,80 ---- b | bbbbbb | b | bbbbbbb | b | bbbbbbbb | d | dddd | d | ddddd | d | dddddd | d | ddddddd | d | dddddddd | ! (11 rows) SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid; relname | aa | cc *************** *** 86,109 **** c | cccccc | c | ccccccc | c | cccccccc | - d | ddd | d | dddd | d | ddddd | d | dddddd | d | ddddddd | d | dddddddd | ! (12 rows) SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid; relname | aa | bb | cc | dd ---------+----------+----+----+---- - d | ddd | | | d | dddd | | | d | ddddd | | | d | dddddd | | | d | ddddddd | | | d | dddddddd | | | ! (6 rows) SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid; relname | aa --- 85,106 ---- c | cccccc | c | ccccccc | c | cccccccc | d | dddd | d | ddddd | d | dddddd | d | ddddddd | d | dddddddd | ! (11 rows) SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid; relname | aa | bb | cc | dd ---------+----------+----+----+---- d | dddd | | | d | ddddd | | | d | dddddd | | | d | ddddddd | | | d | dddddddd | | | ! (5 rows) SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid; relname | aa *************** *** 141,153 **** SELECT relname, d.* FROM ONLY d, pg_class where d.tableoid = pg_class.oid; relname | aa | bb | cc | dd ---------+----------+----+----+---- - d | ddd | | | d | dddd | | | d | ddddd | | | d | dddddd | | | d | ddddddd | | | d | dddddddd | | | ! (6 rows) UPDATE a SET aa='zzzz' WHERE aa='aaaa'; UPDATE ONLY a SET aa='zzzzz' WHERE aa='aaaaa'; --- 138,149 ---- SELECT relname, d.* FROM ONLY d, pg_class where d.tableoid = pg_class.oid; relname | aa | bb | cc | dd ---------+----------+----+----+---- d | dddd | | | d | ddddd | | | d | dddddd | | | d | ddddddd | | | d | dddddddd | | | ! (5 rows) UPDATE a SET aa='zzzz' WHERE aa='aaaa'; UPDATE ONLY a SET aa='zzzzz' WHERE aa='aaaaa'; *************** *** 175,187 **** c | cccccc c | ccccccc c | cccccccc - d | ddd d | dddd d | ddddd d | dddddd d | ddddddd d | dddddddd ! (24 rows) SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid; relname | aa | bb --- 171,182 ---- c | cccccc c | ccccccc c | cccccccc d | dddd d | ddddd d | dddddd d | ddddddd d | dddddddd ! (23 rows) SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid; relname | aa | bb *************** *** 192,204 **** b | bbbbbb | b | bbbbbbb | b | bbbbbbbb | - d | ddd | d | dddd | d | ddddd | d | dddddd | d | ddddddd | d | dddddddd | ! (12 rows) SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid; relname | aa | cc --- 187,198 ---- b | bbbbbb | b | bbbbbbb | b | bbbbbbbb | d | dddd | d | ddddd | d | dddddd | d | ddddddd | d | dddddddd | ! (11 rows) SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid; relname | aa | cc *************** *** 209,232 **** c | cccccc | c | ccccccc | c | cccccccc | - d | ddd | d | dddd | d | ddddd | d | dddddd | d | ddddddd | d | dddddddd | ! (12 rows) SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid; relname | aa | bb | cc | dd ---------+----------+----+----+---- - d | ddd | | | d | dddd | | | d | ddddd | | | d | dddddd | | | d | ddddddd | | | d | dddddddd | | | ! (6 rows) SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid; relname | aa --- 203,224 ---- c | cccccc | c | ccccccc | c | cccccccc | d | dddd | d | ddddd | d | dddddd | d | ddddddd | d | dddddddd | ! (11 rows) SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid; relname | aa | bb | cc | dd ---------+----------+----+----+---- d | dddd | | | d | ddddd | | | d | dddddd | | | d | ddddddd | | | d | dddddddd | | | ! (5 rows) SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid; relname | aa *************** *** 264,276 **** SELECT relname, d.* FROM ONLY d, pg_class where d.tableoid = pg_class.oid; relname | aa | bb | cc | dd ---------+----------+----+----+---- - d | ddd | | | d | dddd | | | d | ddddd | | | d | dddddd | | | d | ddddddd | | | d | dddddddd | | | ! (6 rows) UPDATE b SET aa='new'; SELECT relname, a.* FROM a, pg_class where a.tableoid = pg_class.oid; --- 256,267 ---- SELECT relname, d.* FROM ONLY d, pg_class where d.tableoid = pg_class.oid; relname | aa | bb | cc | dd ---------+----------+----+----+---- d | dddd | | | d | ddddd | | | d | dddddd | | | d | ddddddd | | | d | dddddddd | | | ! (5 rows) UPDATE b SET aa='new'; SELECT relname, a.* FROM a, pg_class where a.tableoid = pg_class.oid; *************** *** 299,306 **** d | new d | new d | new ! d | new ! (24 rows) SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid; relname | aa | bb --- 290,296 ---- d | new d | new d | new ! (23 rows) SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid; relname | aa | bb *************** *** 316,323 **** d | new | d | new | d | new | ! d | new | ! (12 rows) SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid; relname | aa | cc --- 306,312 ---- d | new | d | new | d | new | ! (11 rows) SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid; relname | aa | cc *************** *** 333,340 **** d | new | d | new | d | new | ! d | new | ! (12 rows) SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid; relname | aa | bb | cc | dd --- 322,328 ---- d | new | d | new | d | new | ! (11 rows) SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid; relname | aa | bb | cc | dd *************** *** 344,351 **** d | new | | | d | new | | | d | new | | | ! d | new | | | ! (6 rows) SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid; relname | aa --- 332,338 ---- d | new | | | d | new | | | d | new | | | ! (5 rows) SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid; relname | aa *************** *** 388,395 **** d | new | | | d | new | | | d | new | | | ! d | new | | | ! (6 rows) UPDATE a SET aa='new'; DELETE FROM ONLY c WHERE aa='new'; --- 375,381 ---- d | new | | | d | new | | | d | new | | | ! (5 rows) UPDATE a SET aa='new'; DELETE FROM ONLY c WHERE aa='new'; *************** *** 413,420 **** d | new d | new d | new ! d | new ! (18 rows) SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid; relname | aa | bb --- 399,405 ---- d | new d | new d | new ! (17 rows) SELECT relname, b.* FROM b, pg_class where b.tableoid = pg_class.oid; relname | aa | bb *************** *** 430,437 **** d | new | d | new | d | new | ! d | new | ! (12 rows) SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid; relname | aa | cc --- 415,421 ---- d | new | d | new | d | new | ! (11 rows) SELECT relname, c.* FROM c, pg_class where c.tableoid = pg_class.oid; relname | aa | cc *************** *** 441,448 **** d | new | d | new | d | new | ! d | new | ! (6 rows) SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid; relname | aa | bb | cc | dd --- 425,431 ---- d | new | d | new | d | new | ! (5 rows) SELECT relname, d.* FROM d, pg_class where d.tableoid = pg_class.oid; relname | aa | bb | cc | dd *************** *** 452,459 **** d | new | | | d | new | | | d | new | | | ! d | new | | | ! (6 rows) SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid; relname | aa --- 435,441 ---- d | new | | | d | new | | | d | new | | | ! (5 rows) SELECT relname, a.* FROM ONLY a, pg_class where a.tableoid = pg_class.oid; relname | aa *************** *** 490,497 **** d | new | | | d | new | | | d | new | | | ! d | new | | | ! (6 rows) DELETE FROM a; SELECT relname, a.* FROM a, pg_class where a.tableoid = pg_class.oid; --- 472,478 ---- d | new | | | d | new | | | d | new | | | ! (5 rows) DELETE FROM a; SELECT relname, a.* FROM a, pg_class where a.tableoid = pg_class.oid; ====================================================================== *** ./expected/vacuum.out Sat Jul 20 00:58:14 2002 --- ./results/vacuum.out Fri Mar 7 15:48:41 2003 *************** *** 30,35 **** --- 30,36 ---- VACUUM FULL vactst; UPDATE vactst SET i = i + 1; + ERROR: Relation 124108 does not exist INSERT INTO vactst SELECT * FROM vactst; INSERT INTO vactst SELECT * FROM vactst; INSERT INTO vactst SELECT * FROM vactst; ====================================================================== *** ./expected/sanity_check.out Mon Aug 19 15:33:36 2002 --- ./results/sanity_check.out Fri Mar 7 15:48:48 2003 *************** *** 15,20 **** --- 15,21 ---- bt_name_heap | t bt_txt_heap | t fast_emp4000 | t + fkeys | t func_index_heap | t hash_f8_heap | t hash_i4_heap | t *************** *** 62,68 **** shighway | t tenk1 | t tenk2 | t ! (52 rows) -- -- another sanity check: every system catalog that has OIDs should have --- 63,69 ---- shighway | t tenk1 | t tenk2 | t ! (53 rows) -- -- another sanity check: every system catalog that has OIDs should have ====================================================================== *** ./expected/misc.out Sat Feb 22 20:01:12 2003 --- ./results/misc.out Fri Mar 7 15:48:51 2003 *************** *** 598,603 **** --- 598,604 ---- equipment_r f_star fast_emp4000 + fkeys float4_tbl float8_tbl func_index_heap *************** *** 659,665 **** toyemp varchar_tbl xacttest ! (95 rows) --SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer'))) AS equip_name; SELECT hobbies_by_name('basketball'); --- 660,666 ---- toyemp varchar_tbl xacttest ! (96 rows) --SELECT name(equipment(hobby_construct(text 'skywalking', text 'mer'))) AS equip_name; SELECT hobbies_by_name('basketball'); ======================================================================