Re: Automatic PK values not added to new rows

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

On 5/25/22 11:18 AM, Rich Shepard wrote:
> On Wed, 25 May 2022, Adrian Klaver wrote:
>
> > What is max(person_nbr)?
>
> bustrac=# select max(person_nbr) from people;
>   max -----
>   965
> (1 row)

From:

https://www.postgresql.org/docs/current/functions-sequence.html

SELECT setval('people_person_nbr_seq', 965);

> Rich


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx