Re: [GENERAL] Problem with sequence table

2006-02-08 Thread Richard Huxton
David Goodenough wrote: I have a DB (PostgreSQL of course) which has in the definition of one of its tables that the default is nextval(public.rr_id_seq'::text). When I look in the sequence I see that the "last_value" column is 40, but the largest value in the relevant column is 45. I tried usi

[GENERAL] Problem with sequence table

2006-02-08 Thread David Goodenough
I have a DB (PostgreSQL of course) which has in the definition of one of its tables that the default is nextval(public.rr_id_seq'::text). When I look in the sequence I see that the "last_value" column is 40, but the largest value in the relevant column is 45. I tried using the SQL update command