Re: dropping an unused sequence?

<me@alternize.com> writes:
> during table creation i mistakenly had a SERIAL instead of INTEGER type for
> a value. i removed the default value (nextval....) for this field. still i
> can't drop the old sequence:

Ideally, SERIAL would prevent you from munging the default expression,
too.  What you are doing represents unwarranted tampering with the
implementation of a data type...

Having said that, if you remove the relevant entry in pg_depend then
you'll be able to drop the sequence.

            regards, tom lane