Thread: bigserial coloumn
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?
Regards
Surabhi Ahuja
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
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);