Re: [GENERAL] bigserial coloumn

[Richard Huxton]

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org