Tom Lane writes:
> Rod Taylor <rbt@zort.ca> 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