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 23:09:17
Message-ID: 452c4b59-d43a-f413-114-e35bd5f9d3d2@appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 25 May 2022, Thomas Kellerer wrote:

> If you want to prevent such a situation in the future, you might want to
> consider defining those columns as "generated always as identity" instead
> of "serial".
>
> Then you'd get an error if you try to bypass the database generated values.

Thanks, Thomas.

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-05-26 03:10:39 Re: Automatic PK values not added to new rows
Previous Message Abhishek Bhola 2022-05-25 22:41:33 Re: PG 13.6 : Data corruption error message not being sent to syslog