Обсуждение: Problem with sequence table

Поиск
Список
Период
Сортировка

Problem with sequence table

От
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
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

Re: Problem with sequence table

От
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 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?

SELECT setval('public.rr_id_seq', 46);

--
   Richard Huxton
   Archonet Ltd