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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
