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:21:33
Message-ID: df91bbd8-bcdb-f5f1-8c23-0b16ed21d608@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(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:25:10 Re: Automatic PK values not added to new rows [RESOLVED]
Previous Message Rich Shepard 2022-05-25 18:18:17 Re: Automatic PK values not added to new rows