Re: beta1 packaged

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