On 1/2/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> <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
>
why not let ALTER TYPE drop the sequence if one exists?
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)