| From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: bug in setval? |
| Date: | 2003-03-13 09:48:24 |
| Message-ID: | 50057.80.177.99.193.1047548904.squirrel@ssl.vale-housing.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
It's rumoured that Christopher Kings-Lynne once said:
> 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?
That's bugged me for ages as well. I just never got round to asking about
it...
Regards, Dave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2003-03-13 09:52:36 | Re: Roadmap for FE/BE protocol redesign |
| Previous Message | Mike Mascari | 2003-03-13 07:33:27 | Re: Roadmap for FE/BE protocol redesign |