Re: Automatic PK values not added to new rows

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

On 5/25/22 11:15 AM, Rich Shepard wrote:
> 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;

What is max(person_nbr)?

> Is there a way for me to synchronize the two?
>
> Thanks,
>
> Rich


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx