Re: bug in setval? - Mailing list pgsql-hackers

Christopher Kings-Lynne wrote:
> How do I set the sequence to have next value = 1?  Surely the bounds should
> begin at zero?
> 

No; see:
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/functions-sequence.html

Notice the is_called flag. I think this does what you want:  SELECT setval('foo', 1, false);

Joe