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));