Re: Recording foreign key relationships for the system catalogs - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: Recording foreign key relationships for the system catalogs
Date
Msg-id 194e26d5-41b1-4672-b97d-25eba67fb225@www.fastmail.com
Whole thread Raw
In response to Recording foreign key relationships for the system catalogs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Recording foreign key relationships for the system catalogs
List 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.


pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint
Next
From: "Drouvot, Bertrand"
Date:
Subject: Re: [BUG] orphaned function