pgsql-server: Fix oversight in recent ALTER TABLE improvements.
Log Message:
-----------
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.
Modified Files:
--------------
pgsql-server/src/backend/commands:
tablecmds.c (r1.113 -> r1.114)
(http://developer.postgresql.org/cvsweb.cgi/pgsql-server/src/backend/commands/tablecmds.c.diff?r1=1.113&r2=1.114)
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?
Chris
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