Re: setting serial start value

Hi Michael, from terminal in psql I enter
# ALTER SEQUENCE public.users MINVALUE 9999;
But it doesn't work. I don't think I am specifying the field
correctly. the schema is public, the table is users, the field is id.
Thanks,
Greg
On 20-Jul-06, at 10:49 PM, Michael Fuhr wrote:

> 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