From: | <me(at)alternize(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: dropping an unused sequence? |
Date: | 2006-01-03 03:14:41 |
Message-ID: | 028c01c61013$d6ad6a30$0201a8c0@iwing |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> <me(at)alternize(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Lindstrom | 2006-01-03 14:35:19 | Replacing Tables |
Previous Message | Tom Lane | 2006-01-03 03:00:20 | Re: dropping an unused sequence? |