Re: lifetime of the old CTID

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: lifetime of the old CTID
Date: 2022-07-06 19:33:42
Message-ID: bf9dd01c-5d21-dc25-1ca7-9826e2f3e136@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matthias Apitz 2022-07-06 19:51:48 Re: lifetime of the old CTID
Previous Message David Rowley 2022-07-06 18:53:22 Re: Multiple Indexes