Postgres Pro
Downloads
Home   >   mailing lists

Resetting Serial Column Sequence Number - Mailing list pgsql-general

From Adam
Subject Resetting Serial Column Sequence Number
Date
Msg-id 000b01c6ef48$c3029d10$0200a8c0@PANASONIULSWMR
Whole thread Raw
In response to Versioning/updating schema  ("Jan Cruz" <malebug@gmail.com>)
Responses Re: Resetting Serial Column Sequence Number
List pgsql-general
Tree view
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 wrong?
 
SELECT setval('locations_location_id_seq', (SELECT max(location_id) + 1 FROM locations));

pgsql-general by date:

Previous
From: "Jan Cruz"
Date:
Subject: Re: Versioning/updating schema
Next
From: Andreas Kretschmer
Date:
Subject: Re: Resetting Serial Column Sequence Number