From: Michael Fuhr <mike@fuhr.org>
To: Emil Rachovsky <zsevgymko@yahoo.com>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: [SQL] Without OIDs
Date: Thu, 2 Mar 2006 08:57:52 -0700
Message-ID: <20060302155752.GA6992@winnie.fuhr.org> (raw)
In-Reply-To: <20060302131454.31092.qmail@web54309.mail.yahoo.com>
References: <20060302131454.31092.qmail@web54309.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, zsevgymko@yahoo.com, pgsql-general@postgresql.org
Subject: Re: [SQL] Without OIDs
In-Reply-To: <20060302155752.GA6992@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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