Anything pre-8.2?
On 5/11/07, Rodrigo De León <[EMAIL PROTECTED]> wrote:
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)---
"=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" <[EMAIL PROTECTED]> writes:
> On 5/11/07, Collin Peters <[EMAIL PROTECTED]> wrote:
>> Is there any way to remove the sequence fully?
> ALTER SEQUENCE dtab_i_seq OWNED BY NONE;
Pre-8.2 that command doesn't exist, but you can get the same effect if
you manually
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 no
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 ca
