Re: Convert serial column to regular integer - Mailing list pgsql-sql

"Rodrigo De León" <rdeleonp@gmail.com> writes:
> On 5/11/07, Collin Peters <cadiolis@gmail.com> 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 remove the pg_depend entry that links the sequence to the
column.  Be sure you're removing the right entry ;-)
        regards, tom lane