Re: setting serial start value

On Thu, Jul 20, 2006 at 09:32:56PM -0400, Greg Philpott wrote:
> I have a table with a field called "id" that is a serial field and
> pkey. I would like to set the the sequence to start at 10000 and
> increase sequentially from there but I can't seem to get that to
> work. any suggestions are greatly appreciated.

What have you tried?  ALTER SEQUENCE or setval() should work.

http://www.postgresql.org/docs/7.4/interactive/sql-altersequence.html
http://www.postgresql.org/docs/7.4/interactive/functions-sequence.html

--
Michael Fuhr