Robert Fitzpatrick <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
