Re: Convert serial column to regular integer

From: "Collin Peters" <cadiolis(at)gmail(dot)com>
To:
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Convert serial column to regular integer
Date: 2007-05-11 20:18:02
Message-ID: df01c91b0705111318s59732d19gd881703893a454ea@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Anything pre-8.2?

On 5/11/07, Rodrigo De León <rdeleonp(at)gmail(dot)com> 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;
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2007-05-11 20:32:33 Re: Convert serial column to regular integer
Previous Message imad 2007-05-11 18:19:52 Re: PL/PGSQL Record type question