> How can I reset a sequence number back to 0 ?
>
SELECT setval('sequence_name', 0);In order for this to work, the sequence must have been created with a MINVALUE of 0 (the default MINVALUE is 1) CREATE SEQUENCE sequence_name MINVALUE 0; ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
