pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Without OIDs 2+ messages / 2 participants [nested] [flat]
* Without OIDs @ 2006-03-02 13:14 Emil Rachovsky <zsevgymko@yahoo.com> 0 siblings, 1 reply; 2+ messages in thread From: Emil Rachovsky @ 2006-03-02 13:14 UTC (permalink / raw) To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>; +Cc: pgsql-sql 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [SQL] Without OIDs @ 2006-03-02 15:57 Michael Fuhr <mike@fuhr.org> parent: Emil Rachovsky <zsevgymko@yahoo.com> 0 siblings, 0 replies; 2+ messages in thread From: Michael Fuhr @ 2006-03-02 15:57 UTC (permalink / raw) To: Emil Rachovsky <zsevgymko@yahoo.com>; +Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>; 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-03-02 15:57 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-03-02 13:14 Without OIDs Emil Rachovsky <zsevgymko@yahoo.com> 2006-03-02 15:57 ` Michael Fuhr <mike@fuhr.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox