Re: bigserial coloumn

From: Richard Huxton <dev(at)archonet(dot)com>
To: Surabhi Ahuja <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: bigserial coloumn
Date: 2005-05-24 07:49:43
Message-ID: 4292DC97.6000208@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-05-24 07:51:56 Re: Unsubscribe
Previous Message Patrik Kudo 2005-05-24 07:25:46 Re: Problem merging two rows into same primary key