Postgres Pro
Downloads
Home   >   mailing lists

Re: Automatic PK values not added to new rows - Mailing list pgsql-general

From Rich Shepard
Subject Re: Automatic PK values not added to new rows
Date
Msg-id 452c4b59-d43a-f413-114-e35bd5f9d3d2@appl-ecosys.com
Whole thread Raw
In response to Re: Automatic PK values not added to new rows  (Thomas Kellerer <shammat@gmx.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Abhishek Bhola
Date:
Subject: Re: PG 13.6 : Data corruption error message not being sent to syslog
Next
From: Ron
Date:
Subject: Re: Automatic PK values not added to new rows