From: Collin Peters <cadiolis@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Convert serial column to regular integer
Date: Fri, 11 May 2007 09:24:24 -0700
Message-ID: <df01c91b0705110924k45362880rdcc01db1cae3024f@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cadiolis@gmail.com
Subject: Re: Convert serial column to regular integer
In-Reply-To: <df01c91b0705110924k45362880rdcc01db1cae3024f@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox