Re: lifetime of the old CTID
Ron <ronljohnsonjr@gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Date: 2022-07-06T19:33:42Z
Lists: pgsql-general
On 7/6/22 01:18, Matthias Apitz wrote: [snip] > Ofc, each table has its own primary key(s), used for example for the > SELECT ctid, * FROM d01buch WHERE ... > > As I said, we came to PostgreSQL from Sybase (and Oracle) and Sybase has > for each table a so called SYB_IDENTITY_COLUMN which is static for the > table and its value does not change. The DBA who designed that should be flogged for pretending that SYB_IDENTITY_COLUMN is a primary key. -- Angular momentum makes the world go 'round.