Re: Automatic PK values not added to new rows

[Rich Shepard]

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