Re: beta1 packaged

Giles Lean <giles@nemeton.com.au> writes:
>> Rod Taylor <rbt@zort.ca> writes:
>>> 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.

>   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


I've applied the attached patch, which I think may cure these failures.
        regards, tom lane


*** src/backend/commands/tablecmds.c.orig    Wed Sep  4 17:30:18 2002
--- src/backend/commands/tablecmds.c    Thu Sep 12 17:06:58 2002
***************
*** 2920,2926 ****      * unfortunately).      */     myRel =
makeRangeVar(get_namespace_name(RelationGetNamespace(rel)),
!                          RelationGetRelationName(rel));      /*      * Preset objectAddress fields
--- 2920,2926 ----      * unfortunately).      */     myRel =
makeRangeVar(get_namespace_name(RelationGetNamespace(rel)),
!                          pstrdup(RelationGetRelationName(rel)));      /*      * Preset objectAddress fields