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