Tom Lane writes: > Rod Taylor <[EMAIL PROTECTED]> writes: > > SunOS control.shared2 5.7 Generic_106541-20 sun4u sparc SUNW,Ultra-5_10 > > shows an error in ALTER TABLE tests: > > > ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references > > pktable(ptest1); > > NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY > > check(s) > > + ERROR: Relation "pg_temp_5"."" does not exist > > That's pretty bizarre. Is it reproducible? Can you get in there with a > debugger and try to figure out what's going wrong?
I saw a similar error on a NetBSD-1.5.1/i386 box, but have not been able to reproduce it. Subsequent runs of 'gmake check' have all passed. Until I saw Rod's message I was thinking it was more evidence of hardware flakiness with this particular machine, but perhaps not. *** ./expected/alter_table.out Sat Aug 31 05:23:20 2002 --- ./results/alter_table.out Fri Sep 6 16:54:35 2002 *************** *** 332,337 **** --- 332,338 ---- -- Try (and succeed) ALTER TABLE tmp3 add constraint tmpconstr foreign key (a) references tmp2 matc h full; NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY check(s) + ERROR: Relation "public"."^B^U&W<88><F0>0}" does not exist -- Try (and fail) to create constraint from tmp5(a) to tmp4(a) - unique constr aint on -- tmp4 is a,b ALTER TABLE tmp5 add constraint tmpconstr foreign key(a) references tmp4(a) ma tch full; Regards, Giles ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster