Re: Automatic PK values not added to new rows

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Re: Automatic PK values not added to new rows
Дата
Msg-id dcb54853-9a90-df81-77d6-9f9dce93ce18@appl-ecosys.com
обсуждение исходный текст
Ответ на Re: Automatic PK values not added to new rows  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Automatic PK values not added to new rows
Re: Automatic PK values not added to new rows
Список pgsql-general
On Wed, 25 May 2022, Adrian Klaver wrote:

> Do:
> select * from people_person_nbr_seq;
> and report back the results.

Adrian,

Huh!
bustrac=# select * from people_person_nbr_seq;
  last_value | log_cnt | is_called 
------------+---------+-----------
         683 |      32 | t
(1 row)

It's out of sync with
  select max(person_nbr) from people;

Is there a way for me to synchronize the two?

Thanks,

Rich



В списке pgsql-general по дате отправления: