Horton

Re: Add primary keys to system catalogs

Joel Jacobson <joel@compiler.org>

View thread View on postgr.es
From: "Joel Jacobson" <joel@compiler.org>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: "Robert Haas" <robertmhaas@gmail.com>, "Craig Ringer" <craig.ringer@enterprisedb.com>, "Peter Eisentraut" <peter.eisentraut@2ndquadrant.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2021-01-18T20:56:23Z
Lists: pgsql-hackers 
On Mon, Jan 18, 2021, at 19:33, Tom Lane wrote:
> On second thought, a catalog is overkill; it'd only be useful if the data
> could change after initdb, which this data surely cannot.  The right way
> to expose such info to SQL is with a set-returning function reading a
> constant table in the C code, a la pg_get_keywords().  That way takes a
> whole lot less infrastructure and is just as useful to SQL code.

+1

Commits

  1. Add primary keys and unique constraints to system catalogs