pgsql: Fix assorted syscache lookup sloppiness in partition-relatedcod - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix assorted syscache lookup sloppiness in partition-relatedcod
Date
Msg-id E1eJTfC-0000jt-JW@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix assorted syscache lookup sloppiness in partition-related code.

heap_drop_with_catalog and ATExecDetachPartition neglected to check for
SearchSysCache failures, as noted in bugs #14927 and #14928 from Pan Bian.
Such failures are pretty unlikely, since we should already have some sort
of lock on the rel at these points, but it's neither a good idea nor
per project style to omit a check for failure.

Also, StorePartitionKey contained a syscache lookup that it never did
anything with, including never releasing the result.  Presumably the
reason why we don't see refcount-leak complaints is that the lookup
always fails; but in any case it's pretty useless, so remove it.

All of these errors were evidently introduced by the relation
partitioning feature.  Back-patch to v10 where that came in.

Amit Langote and Tom Lane

Discussion: https://postgr.es/m/20171127090105.1463.3962@wrigleys.postgresql.org
Discussion: https://postgr.es/m/20171127091341.1468.72696@wrigleys.postgresql.org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/cb03fa33aeaea4775b9f3437a2240de4ac9cb630

Modified Files
--------------
src/backend/catalog/heap.c       | 5 ++---
src/backend/commands/tablecmds.c | 3 +++
2 files changed, 5 insertions(+), 3 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix creation of resjunk tlist entries for inherited mixedUPDATE
Next
From: Tom Lane
Date:
Subject: pgsql: Mark some more functions as pg_attribute_noreturn().