$ git bisect good 7966b79801 $ git bisect bad 19252e8ec9 Bisecting: 1902 revisions left to test after this (roughly 11 steps) [c30f54ad732ca5c8762bb68bbe0f51de9137dd72] Detect POLLHUP/POLLRDHUP while running queries.
$ git bisect bad Bisecting: 950 revisions left to test after this (roughly 10 steps) [24b83a5082541bdb1b333b7fcbe92f194128595c] Doc: clarify data type behavior of COALESCE and NULLIF. $ git bisect good Bisecting: 475 revisions left to test after this (roughly 9 steps) [65330622441d7ee08f768c4326825ae903f2595a] doc: Clarify status of SELECT INTO on reference page $ git bisect bad Bisecting: 237 revisions left to test after this (roughly 8 steps) [f234899353f8998bdbd265125ce4a505a312d910] remove missing reference to crypto test from patch 978f869b99 $ git bisect bad Bisecting: 118 revisions left to test after this (roughly 7 steps) [9c83b54a9ccdb111ce693ada2309475197c19d70] Fix a recently-introduced race condition in LISTEN/NOTIFY handling. $ git bisect good Bisecting: 59 revisions left to test after this (roughly 6 steps) [c7aba7c14efdbd9fc1bb44b4cb83bedee0c6a6fc] Support subscripting of arbitrary types, not only arrays. $ git bisect bad Bisecting: 29 revisions left to test after this (roughly 5 steps) [6114040711affa2b0bcf47fa2791187daf8455fb] Small code simplifications $ git bisect good Bisecting: 14 revisions left to test after this (roughly 4 steps) [947789f1f5fb61daf663f26325cbe7cad8197d58] Avoid using tuple from syscache for update of pg_database.datfrozenxid $ git bisect good Bisecting: 7 revisions left to test after this (roughly 3 steps) [f2a69b352de1dffc534c4835010e736018aa94de] Doc: clarify that CREATE TABLE discards redundant unique constraints. $ git bisect good Bisecting: 3 revisions left to test after this (roughly 2 steps) [62ee70331336161cb44733b6c3e0811696d962aa] Teach contain_leaked_vars that assignment SubscriptingRefs are leaky. $ git bisect good Bisecting: 1 revision left to test after this (roughly 1 step) [16c302f51235eaec05a1f85a11c1df04ef3a6785] Simplify code for getting a unicode codepoint's canonical class. $ git bisect good Bisecting: 0 revisions left to test after this (roughly 0 steps) [8b069ef5dca97cd737a5fd64c420df3cd61ec1c9] Change get_constraint_index() to use pg_constraint.conindid $ git bisect bad 8b069ef5dca97cd737a5fd64c420df3cd61ec1c9 is the first bad commit commit 8b069ef5dca97cd737a5fd64c420df3cd61ec1c9 Author: Peter Eisentraut <peter@eisentraut.org> Date: Wed Dec 9 15:12:05 2020 +0100
Change get_constraint_index() to use pg_constraint.conindid
It was still using a scan of pg_depend instead of using the conindid column that has been added since.
Since it is now just a catalog lookup wrapper and not related to pg_depend, move from pg_depend.c to lsyscache.c.
Reviewed-by: Matthias van de Meent <boekewurm+postgres@gmail.com> Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us> Reviewed-by: Michael Paquier <michael@paquier.xyz> Discussion: https://www.postgresql.org/message-id/flat/4688d55c-9a2e-9a5a-d166-5f24fe0bf8db%40enterprisedb.com