Re: beta1 packaged - Mailing list pgsql-hackers

Yep, and he couldn't reproduce it either, and on a different platform. 
I think that indicates we do have a problem in there, it just doesn't
show very often.  He even got ASCII garbage in the error message.

---------------------------------------------------------------------------

Rod Taylor wrote:
> I've not been able to reproduce it, so no.  But there was another report
> from someone else about the same failure on another platform.
> 
> On Tue, 2002-09-10 at 22:50, Bruce Momjian wrote:
> > 
> > Rod, are you still seeing this failure?
> > 
> > ---------------------------------------------------------------------------
> > 
> > Rod Taylor wrote:
> > > On Wed, 2002-09-04 at 22:39, Marc G. Fournier wrote:
> > > > 
> > > > will announce it on -announce tomorrow, if ppl want to take a quick look
> > > > at it ... man pages weren't included, but I did regenerate the docs per
> > > > Peter's suggested commands ...
> > > 
> > > './configure && make check' passes on i386 FreeBSD.
> > > 
> > > SunOS control.shared2 5.7 Generic_106541-20 sun4u sparc SUNW,Ultra-5_10
> > > shows an error in ALTER TABLE tests:
> > > 
> > > 
> > > c> cat src/test/regress/regression.diffs 
> > > *** ./expected/alter_table.out  Fri Aug 30 12:23:20 2002
> > > --- ./results/alter_table.out   Thu Sep  5 07:44:18 2002
> > > ***************
> > > *** 367,374 ****
> > >   -- As should this
> > >   ALTER TABLE FKTABLE ADD FOREIGN KEY(ftest1) references
> > > pktable(ptest1);
> > >   NOTICE:  ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
> > > check(s)
> > >   DROP TABLE pktable cascade;
> > > - NOTICE:  Drop cascades to constraint $2 on table fktable
> > >   NOTICE:  Drop cascades to constraint $1 on table fktable
> > >   DROP TABLE fktable;
> > >   CREATE TEMP TABLE PKTABLE (ptest1 int, ptest2 inet,
> > > --- 367,374 ----
> > >   -- As should this
> > >   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
> > >   DROP TABLE pktable cascade;
> > >   NOTICE:  Drop cascades to constraint $1 on table fktable
> > >   DROP TABLE fktable;
> > >   CREATE TEMP TABLE PKTABLE (ptest1 int, ptest2 inet,
> > > 
> > > ======================================================================
> > > 
> > > 
> > > 
> > > 
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 5: Have you checked our extensive FAQ?
> > > 
> > > http://www.postgresql.org/users-lounge/docs/faq.html
> > > 
> > 
> > -- 
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   pgman@candle.pha.pa.us               |  (610) 359-1001
> >   +  If your life is a hard drive,     |  13 Roberts Road
> >   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
> > 
> -- 
>   Rod Taylor
> 
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073