Re: beta1 packaged

Tom Lane writes:
> Rod Taylor <rbt(at)zort(dot)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