Postgres Pro
Downloads
Home   >   mailing lists

Re: bigserial coloumn - Mailing list pgsql-general

From Richard Huxton
Subject Re: bigserial coloumn
Date
Msg-id 4292DC97.6000208@archonet.com
Whole thread Raw
In response to bigserial coloumn  ("Surabhi Ahuja " <surabhi.ahuja@iiitb.ac.in>)
List pgsql-general
Tree view 
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?

Try a "SELECT * FROM table_id_seq" and see what it's min_value is - I'm
guessing it's set to 1.

HTH
--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Patrik Kudo
Date:
Subject: Re: Problem merging two rows into same primary key
Next
From: Richard Huxton
Date:
Subject: Re: Unsubscribe