Re: Automatic PK values not added to new rows
От
Adrian Klaver
Тема
Re: Automatic PK values not added to new rows
Дата
Msg-id
df91bbd8-bcdb-f5f1-8c23-0b16ed21d608@aklaver.com
Ответ на
Re: Automatic PK values not added to new rows (Rich Shepard)
Список
Дерево обсуждения
Automatic PK values not added to new rows Rich Shepard <rshepard@appl-ecosys.com>
Re: Automatic PK values not added to new rows Adrian Klaver <adrian.klaver@aklaver.com>
Re: Automatic PK values not added to new rows Rich Shepard <rshepard@appl-ecosys.com>
Re: Automatic PK values not added to new rows Thomas Kellerer <shammat@gmx.net>
Re: Automatic PK values not added to new rows Rich Shepard <rshepard@appl-ecosys.com>
Re: Automatic PK values not added to new rows Adrian Klaver <adrian.klaver@aklaver.com>
Re: Automatic PK values not added to new rows Rich Shepard <rshepard@appl-ecosys.com>
Re: Automatic PK values not added to new rows Adrian Klaver <adrian.klaver@aklaver.com>
Re: Automatic PK values not added to new rows [RESOLVED] Rich Shepard <rshepard@appl-ecosys.com>
Re: Automatic PK values not added to new rows "David G. Johnston" <david.g.johnston@gmail.com>
Re: Automatic PK values not added to new rows Rich Shepard <rshepard@appl-ecosys.com>
Re: Automatic PK values not added to new rows Ron <ronljohnsonjr@gmail.com>
Re: Automatic PK values not added to new rows Adrian Klaver <adrian.klaver@aklaver.com>
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@aklaver.com
В списке pgsql-general по дате отправления
