Re: Recording foreign key relationships for the system catalogs

Поиск
Список
Период
Сортировка
От Joel Jacobson
Тема Re: Recording foreign key relationships for the system catalogs
Дата
Msg-id 194e26d5-41b1-4672-b97d-25eba67fb225@www.fastmail.com
обсуждение исходный текст
Ответ на Recording foreign key relationships for the system catalogs  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Recording foreign key relationships for the system catalogs  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint
Следующее
От: "Drouvot, Bertrand"
Дата:
Сообщение: Re: [BUG] orphaned function