<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