Обсуждение: Without OIDs

Hello,

I'm creating a temporary table in a function and using
Alter Table ... Without OIDs, but when the function is
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?

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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