On 5/11/07, Collin Peters <[EMAIL PROTECTED]> wrote:
I have a need to convert an incorrectly typed serial column to a
regular integer column. Basically this just involves removing the
sequence. I am able to successfully remove the default value (DROP
DEFAULT) (which seems to use nextval) and now pgadmin does show the
column as an integer, but I cannot remove the sequence as it says it
is still in use. If I look at the column in pgadmin the sequence
field is still filled in with the sequence but it is grayed out. Is
there any way to remove the sequence fully?
Regards,
Collin
CREATE TABLE dtab (i SERIAL);
ALTER TABLE dtab ALTER COLUMN i DROP DEFAULT;
ALTER SEQUENCE dtab_i_seq OWNED BY NONE;
DROP SEQUENCE dtab_i_seq;
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
