pgsql: Flush relcache entries when their FKs are meddled with

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема pgsql: Flush relcache entries when their FKs are meddled with
Дата
Msg-id E1gliEP-0003f5-NU@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Flush relcache entries when their FKs are meddled with

Back in commit 100340e2dcd0, we made relcache entries keep lists of the
foreign keys applying to the relation -- but we forgot to update
CacheInvalidateHeapTuple to flush those entries when new FKs got created
or existing ones updated/deleted.  No bugs appear to have been reported
that would be explained by this ommission, but I noticed the problem
while working on an unrelated bugfix which clearly showed it.  Fix by
adding relcache flush on relevant foreign key changes.

Backpatch to 9.6, like the aforementioned commit.

Discussion: https://postgr.es/m/201901211927.7mmhschxlejh@alvherre.pgsql
Reviewed-by: Tom Lane

Branch
------
REL9_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/4aead13a751f86a9e143d3ee931171a11fd7bf7e

Modified Files
--------------
src/backend/utils/cache/inval.c | 20 +++++++++++++++++++-
1 file changed, 19 insertions(+), 1 deletion(-)


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Second try at fixing ecpglib thread-safety problem.
Следующее
От: Alvaro Herrera
Дата:
Сообщение: pgsql: Create action triggers when partitions are detached