Re: Without OIDs - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: Without OIDs
Date
Msg-id 20060302155752.GA6992@winnie.fuhr.org
Whole thread Raw
In response to Without OIDs  (Emil Rachovsky <zsevgymko@yahoo.com>)
List pgsql-sql
On Thu, Mar 02, 2006 at 05:14:54AM -0800, Emil Rachovsky wrote:
> I'm creating a temporary table in a function and using
> Alter Table ... Without OIDs, but when the function is

Why alter the table?  Why not specify WITHOUT OIDS when you create
the table?

> called for the second time I get an error "relation
> with OIDs ... doesn't exist" on an insert statement to
> the table. I'm using Postgre 8.0 which says that
> supports without OIDs. Any suggestions?

This problem isn't related to WITHOUT OIDS.  See FAQ 4.19 for an
explanation:

http://www.postgresql.org/docs/faqs.FAQ.html#item4.19

--
Michael Fuhr

pgsql-sql by date:

Previous
From: george young
Date:
Subject: Re: Change date format through an environmental variable?
Next
From: "Chaz."
Date:
Subject: Question about Sql SELECT and optimizer