Re: dropping sequences - Mailing list pgsql-general

From Tom Lane
Subject Re: dropping sequences
Date
Msg-id 11270.1056060281@sss.pgh.pa.us
Whole thread Raw
In response to dropping sequences  (Erik Price <eprice@ptc.com>)
Responses Re: dropping sequences  (Erik Price <eprice@ptc.com>)
List pgsql-general
Erik Price <eprice@ptc.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() ?

            regards, tom lane

pgsql-general by date:

Previous
From: Erik Price
Date:
Subject: dropping sequences
Next
From: Erik Price
Date:
Subject: Re: dropping sequences