Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group