| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Emil Rachovsky <zsevgymko(at)yahoo(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: [SQL] Without OIDs |
| Date: | 2006-03-02 15:57:52 |
| Message-ID: | 20060302155752.GA6992@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2006-03-02 16:05:45 | Re: Need a GNU SQL CLI tool for Win32 with ODBC support. |
| Previous Message | Tom Lane | 2006-03-02 15:49:11 | Re: Postgres does not accept socket connections |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2006-03-02 16:13:09 | Re: [SQL] Interval subtracting |
| Previous Message | george young | 2006-03-02 15:33:10 | Re: Change date format through an environmental variable? |