bug in setval? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject bug in setval?
Date
Msg-id 0a3901c2e90f$a5492250$6500a8c0@fhp.internal
Whole thread Raw
Responses Re: bug in setval?  (Joe Conway <mail@joeconway.com>)
Re: bug in setval?  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-hackers
When I create a new table with a serial column, the first row defaults to
inserting '1'.

If I delete all the rows from the table and want to reset the sequence, I
can't:

ERROR:  users_health_types_type_id_seq.setval: value 0 is out of bounds
(1,9223372036854775807)

How do I set the sequence to have next value = 1?  Surely the bounds should
begin at zero?

Chris



pgsql-hackers by date:

Previous
From: Sailesh Krishnamurthy
Date:
Subject: some more docbook help
Next
From: Joe Conway
Date:
Subject: Re: bug in setval?