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