BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can

From: "Jasen Betts" <jasen(at)treshna(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can
Date: 2007-06-22 01:55:50
Message-ID: 200706220155.l5M1toH9061867@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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=#

this worked in version 8.1.8 (linux)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Zdenek Kotala 2007-06-22 07:27:07 Re: BUG #3403: ver 8.2 can't add serial column to temp table,but 8.1 can
Previous Message Tom Lane 2007-06-21 15:23:56 Re: BUG #3401: PITR does not work in the case of recovery_target_xid = 'SELECT_only_transaction_ID'