Re: bigserial coloumn - Mailing list pgsql-general

From Scott Marlowe
Subject Re: bigserial coloumn
Date
Msg-id 1116941232.31821.249.camel@state.g2switchworks.com
Whole thread Raw
In response to bigserial coloumn  ("Surabhi Ahuja " <surabhi.ahuja@iiitb.ac.in>)
List pgsql-general
On Tue, 2005-05-24 at 00:13, Surabhi Ahuja wrote:
> I have a table in which one attribute "id" is a bigserial
>
> when i say
> select setval('table_id_seq', 0);
> it says: values 0 is out of bounds.
> what should i do?

IS that what you really want, or do you just want the first assignment
to be a 1?

If so, then just do setval('table_id_seq', 1, FALSE);

pgsql-general by date:

Previous
From: Jerome Macaranas
Date:
Subject: Re: Need input on postgres used for phpBB
Next
From: James Croft
Date:
Subject: PostgreSQL release schedule