Re: pgsql-server: Fix oversight in recent ALTER TABLE

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