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);