Thread

1. Re: beta1 packaged

   Giles Lean <giles@nemeton.com.au> — 2002-09-06T14:02:27Z

   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
   
   

2. Re: beta1 packaged

   Tom Lane <tgl@sss.pgh.pa.us> — 2002-09-12T21:18:54Z

   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