Re: Bug #857: [7.3] Attribute oid not found in a temporary table

From: JMM Moi-Meme Maitre du Monde <j6m(at)cvni(dot)net>
To: JMM Moi-Meme Maitre du Monde <j6m(at)cvni(dot)net>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #857: [7.3] Attribute oid not found in a temporary table
Date: 2002-12-26 14:33:03
Message-ID: 20021226143303.GD24045@delta.cvni.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Wrong ! The workaround works in 7.3 but is not backward compatible
with prior 7.x.y version.

I began reverting to 7.2.3 :( Anyway, I will survive ;)

On Thu, Dec 26, 2002 at 09:02:08AM +0100, JMM Moi-Meme Maitre du Monde wrote:
> Yes, it works. Thanks.
>
> I will just have to alter some 50 scripts, but that's better than
> having to revert my DBs (~18 GB) to 7.2.3 while waiting for 7.4.
>
> On Wed, Dec 25, 2002 at 10:58:41PM -0500, Bruce Momjian wrote:
> >
> > This is a known problem with 7.3.X. It doesn't create an oid column as
> > part of SELECT INTO ....
> >
> > We have a TODO item:
> >
> > * Fix SELECT ... INTO and CREATE TABLE AS to have appopriate OID column
> >
> > so this will be fixed, hopefully in 7.4. We couldn't fix it in 7.3.X
> > without causing more serious problems. If you specify the oid column as
> > part of the SELECT INTO, it will take the oid from the original table
> > and put it in your new table. Does that help you?
> >

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2002-12-26 15:17:19 Bug #858: bitfromint4 not present in 7.3.1
Previous Message Gaetano Mendola 2002-12-26 12:15:24 pgdb.py is still wrong in Postgres 7.3.1 rpm