> I don't see any bug there. The ALTER DROP DEFAULT command does not > remove the sequence's dependence on foo.id; nor for that matter > does ALTER SET DEFAULT create an auto-drop dependency on the new > table. See ALTER SEQUENCE OWNED BY if you want to dissociate a > serial column's sequence from the column, or reattach it to another > column. > > Formally speaking, a "serial column" is shorthand for creating an > integer (or bigint) column, creating a sequence, associating them as > though by ALTER SEQUENCE OWNED BY, and setting the column's default > to nextval('sequence-name').
I stand corrected. It would be nice if \ds or \ds+ or something showed this relationship so it was evident. That's more of a feature request than a bug fix tho. apologies for the misdirection. -Todd -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs