Search Postgresql Archives

Re: Automatic PK values not added to new rows

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Automatic PK values not added to new rows
From: Rich Shepard <rshepard@xxxxxxxxxxxxxxx>
Date: Wed, 25 May 2022 16:09:17 -0700 (PDT)
In-reply-to: <6d67d16b-7cdd-2f40-9ebe-82a499eb11c2@gmx.net>
References: <e4a17cde-9941-5eb5-e88d-246577e4488c@appl-ecosys.com> <c8e3b0d2-dd92-3764-74c2-fb70b6b8bbc4@aklaver.com> <dcb54853-9a90-df81-77d6-9f9dce93ce18@appl-ecosys.com> <6d67d16b-7cdd-2f40-9ebe-82a499eb11c2@gmx.net>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Automatic PK values not added to new rows
  - From: Rich Shepard
- Re: Automatic PK values not added to new rows
  - From: Adrian Klaver
- Re: Automatic PK values not added to new rows
  - From: Rich Shepard
- Re: Automatic PK values not added to new rows
  - From: Thomas Kellerer

Prev by Date: Re: PG 13.6 : Data corruption error message not being sent to syslog
Next by Date: Re: Automatic PK values not added to new rows
Previous by thread: Re: Automatic PK values not added to new rows
Next by thread: Re: Automatic PK values not added to new rows
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux