Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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
In response to
pgsql-committers by date
|Next:||From: Tom Lane||Date: 2004-06-11 01:34:14|
|Subject: Re: pgsql-server: Clean up generation of default names |
|Previous:||From: Christopher Kings-Lynne||Date: 2004-06-11 01:14:37|
|Subject: Re: pgsql-server: Clean up generation of default names|