pgsql: Change get_constraint_index() to use pg_constraint.conindid - Mailing list pgsql-committers

From Peter Eisentraut
Subject pgsql: Change get_constraint_index() to use pg_constraint.conindid
Date
Msg-id E1kn0lo-0002Mn-HT@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/8b069ef5dca97cd737a5fd64c420df3cd61ec1c9

Modified Files
--------------
src/backend/catalog/pg_depend.c      | 69 ------------------------------------
src/backend/commands/tablecmds.c     |  1 -
src/backend/optimizer/util/plancat.c |  1 -
src/backend/utils/adt/ruleutils.c    |  3 +-
src/backend/utils/cache/lsyscache.c  | 27 ++++++++++++++
src/include/catalog/dependency.h     |  2 --
src/include/utils/lsyscache.h        |  1 +
7 files changed, 29 insertions(+), 75 deletions(-)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Simplify code for getting a unicode codepoint's canonical class.
Next
From: Tom Lane
Date:
Subject: pgsql: Support subscripting of arbitrary types, not only arrays.