Horton

Re: Recording foreign key relationships for the system catalogs

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Joel Jacobson" <joel@compiler.org>
Cc: pgsql-hackers@lists.postgresql.org, "Peter Eisentraut" <peter.eisentraut@enterprisedb.com>
Date: 2021-02-01T20:03:51Z
Lists: pgsql-hackers 
"Joel Jacobson" <joel@compiler.org> writes:
> The is_array OUT parameter doesn't say which of the possibly many fkcols that is the array column.

Yeah, I didn't write the sgml docs yet, but the comments explain that
the array is always the last fkcol.  Maybe someday that won't be
general enough, but we can cross that bridge when we come to it.

			regards, tom lane

Commits

  1. Remove special BKI_LOOKUP magic for namespace and role OIDs.

  2. Retire findoidjoins.

  3. Build in some knowledge about foreign-key relationships in the catalogs.