Change get_constraint_index() to use pg_constraint.conindid
authorPeter Eisentraut <peter@eisentraut.org>
Wed, 9 Dec 2020 14:12:05 +0000 (15:12 +0100)
committerPeter Eisentraut <peter@eisentraut.org>
Wed, 9 Dec 2020 14:41:45 +0000 (15:41 +0100)
commit8b069ef5dca97cd737a5fd64c420df3cd61ec1c9
tree003a455f78a362610fdced6c4ad8be1ac846ba4d
parent16c302f51235eaec05a1f85a11c1df04ef3a6785
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
src/backend/catalog/pg_depend.c
src/backend/commands/tablecmds.c
src/backend/optimizer/util/plancat.c
src/backend/utils/adt/ruleutils.c
src/backend/utils/cache/lsyscache.c
src/include/catalog/dependency.h
src/include/utils/lsyscache.h