Re: Recording foreign key relationships for the system catalogs

From: "Joel Jacobson" <joel(at)compiler(dot)org>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: "Peter Eisentraut" <peter(dot)eisentraut(at)enterprisedb(dot)com>
Subject: Re: Recording foreign key relationships for the system catalogs
Date: 2021-02-01 13:41:11
Message-ID: 194e26d5-41b1-4672-b97d-25eba67fb225@www.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Could it be an idea to also add

OUT can_be_zero boolean

to pg_get_catalog_foreign_keys()'s out parameters?

This information is useful to know if one should be doing an INNER JOIN or a LEFT JOIN on the foreign keys.

The information is mostly available in the documentation already,
but not quite accurate, which I've proposed a patch [1] to fix.

[1] https://www.postgresql.org/message-id/4ed9a372-7bf9-479a-926c-ae8e774717a8@www.fastmail.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Drouvot, Bertrand 2021-02-01 14:06:07 Re: [BUG] orphaned function
Previous Message Masahiko Sawada 2021-02-01 13:39:35 Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint