> 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

Reply via email to