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.

thanks. i'm using EMS SQL Manager 3. when creating a SERIAL data field, it
is shown as INTEGER afterwards with the "nextval(..)" default value. thats
how and why i was able to make it a "pure" integer ;-)

i'll fill a bug report at ems about this.

thanks for your fast help,
thomas