Re: Automatic PK values not added to new rows

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Automatic PK values not added to new rows
Date: 2022-05-25 18:15:27
Message-ID: dcb54853-9a90-df81-77d6-9f9dce93ce18@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-05-25 18:16:56 Re: Automatic PK values not added to new rows
Previous Message Bryn Llewellyn 2022-05-25 18:08:11 Re: "Join Postgres on Slack" ?