Postgres Pro
Downloads
Home   >   mailing lists

Re: Unique constraint violation on serial column - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Unique constraint violation on serial column
Date
Msg-id 20050412155601.GH17283@dcc.uchile.cl
Whole thread Raw
In response to Re: Unique constraint violation on serial column  (Bill Chandler <billybobc1210@yahoo.com>)
List pgsql-general
Tree view 
On Tue, Apr 12, 2005 at 08:48:15AM -0700, Bill Chandler wrote:

> How does one find out the current sequence value?  Is
> there a way to change it?

Using the function setval() you can change it.  SELECT * from
sequencename to find out.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Si quieres ser creativo, aprende el arte de perder el tiempo"

pgsql-general by date:

Previous
From: Bill Chandler
Date:
Subject: Re: Unique constraint violation on serial column
Next
From: Bill Chandler
Date:
Subject: Re: Unique constraint violation on serial column