I am seeing the following parallel regression test failures. Any idea
on the cause?
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
*** ./expected/constraints.out Fri Jul 25 17:36:36 2003
--- ./results/constraints.out Fri Jul 25 17:37:07 2003
***************
*** 80,102 ****
CREATE TABLE CHECK2_TBL (x int, y text, z int,
CONSTRAINT SEQUENCE_CON
CHECK (x > 3 and y <> 'check failed' and z < 8));
INSERT INTO CHECK2_TBL VALUES (4, 'check ok', -2);
INSERT INTO CHECK2_TBL VALUES (1, 'x check failed', -2);
! ERROR: new row for relation "check2_tbl" violates CHECK constraint "sequence_con"
INSERT INTO CHECK2_TBL VALUES (5, 'z check failed', 10);
! ERROR: new row for relation "check2_tbl" violates CHECK constraint "sequence_con"
INSERT INTO CHECK2_TBL VALUES (0, 'check failed', -2);
! ERROR: new row for relation "check2_tbl" violates CHECK constraint "sequence_con"
INSERT INTO CHECK2_TBL VALUES (6, 'check failed', 11);
! ERROR: new row for relation "check2_tbl" violates CHECK constraint "sequence_con"
INSERT INTO CHECK2_TBL VALUES (7, 'check ok', 7);
SELECT '' AS two, * from CHECK2_TBL;
! two | x | y | z
! -----+---+----------+----
! | 4 | check ok | -2
! | 7 | check ok | 7
! (2 rows)
!
--
-- Check constraints on INSERT
--
--- 80,100 ----
CREATE TABLE CHECK2_TBL (x int, y text, z int,
CONSTRAINT SEQUENCE_CON
CHECK (x > 3 and y <> 'check failed' and z < 8));
+ ERROR: cache lookup failed for relation 126262
INSERT INTO CHECK2_TBL VALUES (4, 'check ok', -2);
+ ERROR: relation "check2_tbl" does not exist
INSERT INTO CHECK2_TBL VALUES (1, 'x check failed', -2);
! ERROR: relation "check2_tbl" does not exist
INSERT INTO CHECK2_TBL VALUES (5, 'z check failed', 10);
! ERROR: relation "check2_tbl" does not exist
INSERT INTO CHECK2_TBL VALUES (0, 'check failed', -2);
! ERROR: relation "check2_tbl" does not exist
INSERT INTO CHECK2_TBL VALUES (6, 'check failed', 11);
! ERROR: relation "check2_tbl" does not exist
INSERT INTO CHECK2_TBL VALUES (7, 'check ok', 7);
+ ERROR: relation "check2_tbl" does not exist
SELECT '' AS two, * from CHECK2_TBL;
! ERROR: relation "check2_tbl" does not exist
--
-- Check constraints on INSERT
--
======================================================================
*** ./expected/triggers.out Fri Jul 25 12:38:34 2003
--- ./results/triggers.out Fri Jul 25 17:37:06 2003
***************
*** 91,96 ****
--- 91,97 ----
NOTICE: check_pkeys_fkey_cascade: 1 tuple(s) of fkeys2 are deleted
DROP TABLE pkeys;
DROP TABLE fkeys;
+ ERROR: cache lookup failed for relation 122552
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/sanity_check.out Wed May 28 12:04:02 2003
--- ./results/sanity_check.out Fri Jul 25 17:37:14 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 Fri Jul 25 17:36:36 2003
--- ./results/misc.out Fri Jul 25 17:37:17 2003
***************
*** 580,586 ****
c
c_star
char_tbl
- check2_tbl
check_seq
check_tbl
circle_tbl
--- 580,585 ----
***************
*** 598,603 ****
--- 597,603 ----
equipment_r
f_star
fast_emp4000
+ fkeys
float4_tbl
float8_tbl
func_index_heap
======================================================================
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
