Dropping sequences
I have changed the default sequence on a primary key integer (created as
SERIAL) field in a table, but it will not let me drop the old sequence
and continues to tell me that the sequence is required by the table. Can
someone tell me what is required to get this dropped? I am just paranoid
that it could be using the old sequence still even though it seems all
is coming from the new sequence.
--
Robert
Robert Fitzpatrick <robert@webtent.com> writes:
I have changed the default sequence on a primary key integer (created as
SERIAL) field in a table, but it will not let me drop the old sequence
and continues to tell me that the sequence is required by the table. Can
someone tell me what is required to get this dropped?
Theoretically you have to drop the serial column.
If you don't mind mucking with system catalogs, you could remove the
pg_depend entry linking the sequence to the column, and then it would
let you drop the sequence.
regards, tom lane