Re: [GENERAL] Resetting Serial Column Sequence Number

2006-10-14 Thread Shane Ambler
Andreas Kretschmer wrote: Andreas Kretschmer <[EMAIL PROTECTED]> schrieb: Adam <[EMAIL PROTECTED]> schrieb: I just emptied my table and I want all my new inserts to start with a 'location_id' of '1'. The table is named "locations" with a SERIAL column "location_id" If you want to start at 1

Re: [GENERAL] Resetting Serial Column Sequence Number

2006-10-13 Thread Andreas Kretschmer
Andreas Kretschmer <[EMAIL PROTECTED]> schrieb: > Adam <[EMAIL PROTECTED]> schrieb: > > > > > I just emptied my table and I want all my new inserts to start with a > > 'location_id' of '1'. The table is named "locations" with a SERIAL column > > "location_id" > > > > I tried the below SQL to r

Re: [GENERAL] Resetting Serial Column Sequence Number

2006-10-13 Thread Andreas Kretschmer
Adam <[EMAIL PROTECTED]> schrieb: > > I just emptied my table and I want all my new inserts to start with a > 'location_id' of '1'. The table is named "locations" with a SERIAL column > "location_id" > > I tried the below SQL to rest the sequence ID but it's not working. What am I > doing wron