Re: pgsql-server: Fix oversight in recent ALTER TABLE - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql-server: Fix oversight in recent ALTER TABLE
Date
Msg-id 17572.1086917259@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql-server: Fix oversight in recent ALTER TABLE  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-committers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>> Fix oversight in recent ALTER TABLE improvements.  We now support
>> ALTER TABLE tab ADD COLUMN col SERIAL, but we forgot to install the
>> dependency between the column and the sequence, so the sequence
>> would not go away if you dropped the table later.

> What if you ALTER TABLE / TYPE SERIAL?

You can't --- it won't recognize the SERIAL alias in that context.

            regards, tom lane

pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql-server: When using extended-query protocol, postpone planning of
Next
From: Tom Lane
Date:
Subject: Re: pgsql-server: Clean up generation of default names