From: | Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM> |
---|---|
To: | Jasen Betts <jasen(at)treshna(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can |
Date: | 2007-06-22 07:27:07 |
Message-ID: | 467B79CB.9050205@sun.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Jasen Betts wrote:
> The following bug has been logged online:
>
> Bug reference: 3403
> Logged by: Jasen Betts
> Email address: jasen(at)treshna(dot)com
> PostgreSQL version: 8.2.0
> Operating system: window XP (vmware)
> Description: ver 8.2 can't add serial column to temp table,but 8.1
> can
> Details:
>
> gymmaster=# select version();
> version
>
> --------
> ----------------------------------------------------------------------------
> ------
> PostgreSQL 8.2.0 on i686-pc-mingw32, compiled by GCC cc.exe (GCC) 3.4.2
> (mingw-special)
> (1 row)
> template1=# create temp table foo ( x text);
> CREATE TABLE
> template1=# alter table foo add column y text ;
> ALTER TABLE
> template1=# alter table foo add column id serial;
> NOTICE: ALTER TABLE will create implicit sequence "foo_id_seq" for serial
> colum
> n "foo.id"
> ERROR: relation "public.foo" does not exist
> template1=#
It does not work on 8.2.4 as well. It seems PG lost information about
schema and try to use default schema. Following command works well:
alter table pg_temp.foo add column id serial;
It could be use as workaround.
Zdenek
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-06-22 07:38:39 | Re: BUG #3401: PITR does not work in the case ofrecovery_target_xid = 'SELECT_only_transaction_ID' |
Previous Message | Jasen Betts | 2007-06-22 01:55:50 | BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can |