Re: dropping sequences

From: Erik Price <eprice(at)ptc(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dropping sequences
Date: 2003-06-19 22:13:29
Message-ID: 3EF23589.8080901@ptc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Erik Price <eprice(at)ptc(dot)com> writes:
>
>>So, is the solution to drop the column first, then drop the sequence,
>>then re-create the column by using ALTER TABLE ?
>
>
> Perhaps what you are really looking to do is just to reset the sequence
> counters with setval() ?

Believe it or not, I really want to remove the sequences altogether. It
may sound strange. I'm experimenting.

Erik

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-06-19 22:29:57 Re: dropping sequences
Previous Message Tom Lane 2003-06-19 22:04:41 Re: dropping sequences