> 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
