Horton
Menu

Re: Using CTID system column as a "temporary" primary key

Christophe Pettus <xof@thebuild.com>

View thread
From: Christophe Pettus <xof@thebuild.com>
To: Sebastien Flaesch <sebastien.flaesch@4js.com>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, Kirk Wolak <wolakk@gmail.com>, Geoff Winkless <pgsqladmin@geoff.dj>, pgsql-general <pgsql-general@lists.postgresql.org>
Date: 2023-03-29T19:18:30Z
Lists: pgsql-general 

> 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 will rapidly become unusable if it tried to adopt them all.  This one in particular seems particularly hacky and misguided (as well as non-standard-compliant).