Postgres Pro
Downloads
Home   >   mailing lists

Re: Using CTID system column as a "temporary" primary key - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Using CTID system column as a "temporary" primary key
Date
Msg-id E7B36E22-D882-44E6-8995-3B50908333F6@thebuild.com
Whole thread Raw
In response to Re: Using CTID system column as a "temporary" primary key  (Sebastien Flaesch <sebastien.flaesch@4js.com>)
List pgsql-general
Tree view 

> On Mar 29, 2023, at 12:11, Sebastien Flaesch <sebastien.flaesch@4js.com> wrote:
> But to make PostgreSQL more Informix-compatible, zero should have been considered as well.

There is an infinite family of strange features that various databases have (DUAL from Oracle, anyone?); PostgreSQL
willrapidly become unusable if it tried to adopt them all.  This one in particular seems particularly hacky and
misguided(as well as non-standard-compliant).

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Using CTID system column as a "temporary" primary key
Next
From: Adrian Klaver
Date:
Subject: Re: Using CTID system column as a "temporary" primary key