Problem with sequence table

From: David Goodenough <david(dot)goodenough(at)btconnect(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with sequence table
Date: 2006-02-08 12:40:39
Message-ID: 200602081240.39258.david.goodenough@btconnect.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
to update this value but it would not let me. How do I get rr_id_seq in step
with the data in the table?

David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-02-08 12:53:00 Re: Problem with sequence table
Previous Message Richard Huxton 2006-02-08 11:18:55 Re: loading pg_description ... FATAL: duplicate key violates