Jasen Betts wrote:
The following bug has been logged online:
Bug reference: 3403
Logged by: Jasen Betts
Email address: [EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
