Re: get_constraint_index() and conindid

Поиск
Список
Период
Сортировка
От Matthias van de Meent
Тема Re: get_constraint_index() and conindid
Дата
Msg-id CAEze2WjBDFL3tSUTkaijZOa-pg3k_VcmyQzMXtW-qWQNfj-SKw@mail.gmail.com
обсуждение исходный текст
Ответ на get_constraint_index() and conindid  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Ответы Re: get_constraint_index() and conindid  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, 7 Dec 2020 at 11:09, Peter Eisentraut
<peter.eisentraut@enterprisedb.com> wrote:
>
> get_constraint_index() does its work by going through pg_depend.  It was
> added before pg_constraint.conindid was added, and some callers are
> still not changed.  Are there reasons for that?  Probably not.  The
> attached patch changes get_constraint_index() to an lsyscache-style
> lookup instead.

This looks quite reasonable, and it passes "make installcheck-world".

Only thing I could think of is that it maybe could use a (small)
comment in the message on that/why get_constraint_index is moved to
utils/lsyscache from catalog/dependency, as that took me some time to
understand.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Daniil Zakhlystov
Дата:
Сообщение: Re: libpq compression
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: autovac issue with large number of tables