Re: [GENERAL] setting serial start value

2006-07-20 Thread Greg Philpott
Thanks Michael that did the trick! Greg On 21-Jul-06, at 12:05 AM, Michael Fuhr wrote: On Thu, Jul 20, 2006 at 11:35:51PM -0400, Greg Philpott wrote: Hi Michael, from terminal in psql I enter # ALTER SEQUENCE public.users MINVALUE ; But it doesn't work. I don't think I am spec

Re: [GENERAL] setting serial start value

2006-07-20 Thread Greg Philpott
n 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 1 and increase sequentially from there but I can't seem to get that to work. any suggestion

[GENERAL] setting serial start value

2006-07-20 Thread Greg Philpott
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 1 and increase sequentially from there but I can't seem to get that to work. any suggestions are greatly appreciated. I am using version 7.4.7 Greg