Re: Automatic PK values not added to new rows

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Automatic PK values not added to new rows
Date: 2022-05-25 18:16:56
Message-ID: ae9e42e9-6464-a262-a061-a4cc75c224cd@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2022-05-25 18:17:16 Re: Automatic PK values not added to new rows
Previous Message Rich Shepard 2022-05-25 18:15:27 Re: Automatic PK values not added to new rows