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 |