Re: dropping sequences

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

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() ?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Price 2003-06-19 22:13:29 Re: dropping sequences
Previous Message Erik Price 2003-06-19 21:50:36 dropping sequences