Re: Bug #857: [7.3] Attribute oid not found in a temporary table - Mailing list pgsql-bugs

From JMM Moi-Meme Maitre du Monde
Subject Re: Bug #857: [7.3] Attribute oid not found in a temporary table
Date
Msg-id 20021226143303.GD24045@delta.cvni.net
Whole thread Raw
In response to Re: Bug #857: [7.3] Attribute oid not found in a temporary table  (JMM Moi-Meme Maitre du Monde <j6m@cvni.net>)
Responses Re: Bug #857: [7.3] Attribute oid not found in a temporary table
List 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?
> >

pgsql-bugs by date:

Previous
From: "Gaetano Mendola"
Date:
Subject: pgdb.py is still wrong in Postgres 7.3.1 rpm
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #858: bitfromint4 not present in 7.3.1