Re: beta1 packaged

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Giles Lean <giles(at)nemeton(dot)com(dot)au>
Cc: Rod Taylor <rbt(at)zort(dot)ca>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: beta1 packaged
Date: 2002-09-12 21:18:54
Message-ID: 12564.1031865534@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Giles Lean <giles(at)nemeton(dot)com(dot)au> writes:
>> Rod Taylor <rbt(at)zort(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Gavin M. Roy 2002-09-12 21:42:26 Re: [GENERAL] Looking for more "big name" places that use PostgreSQL
Previous Message Justin Clift 2002-09-12 21:11:21 Re: Looking for more "big name" places that use PostgreSQL