From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Fix assorted bugs in pg_get_partition_constraintdef(). |
Date: | 2018-09-27 22:15:34 |
Message-ID: | E1g5eZK-0006iF-IE@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Fix assorted bugs in pg_get_partition_constraintdef().
It failed if passed a nonexistent relation OID, or one that was a non-heap
relation, because of blindly applying heap_open to a user-supplied OID.
This is not OK behavior for a SQL-exposed function; we have a project
policy that we should return NULL in such cases. Moreover, since
pg_get_partition_constraintdef ought now to work on indexes, restricting
it to heaps is flat wrong anyway.
The underlying function generate_partition_qual() wasn't on board with
indexes having partition quals either, nor for that matter with rels
having relispartition set but yet null relpartbound. (One wonders
whether the person who wrote the function comment blocks claiming that
these functions allow a missing relpartbound had ever tested it.)
Fix by testing relispartition before opening the rel, and by using
relation_open not heap_open. (If any other relkinds ever grow the
ability to have relispartition set, the code will work with them
automatically.) Also, don't reject null relpartbound in
generate_partition_qual.
Back-patch to v11, and all but the null-relpartbound change to v10.
(It's not really necessary to change generate_partition_qual at all
in v10, but I thought s/heap_open/relation_open/ would be a good
idea anyway just to keep the code in sync with later branches.)
Per report from Justin Pryzby.
Discussion: https://postgr.es/m/20180927200020.GJ776@telsasoft.com
Branch
------
REL_11_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/49507dec46010cc781a4b4575b6c2ff5088b13d3
Modified Files
--------------
src/backend/utils/cache/lsyscache.c | 24 +++++++++++++++++
src/backend/utils/cache/partcache.c | 48 ++++++++++++++++++++--------------
src/include/utils/lsyscache.h | 1 +
src/test/regress/expected/indexing.out | 19 ++++++++++++++
src/test/regress/sql/indexing.sql | 2 ++
5 files changed, 75 insertions(+), 19 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2018-09-28 03:01:14 | pgsql: Fix WAL recycling on standbys depending on archive_mode |
Previous Message | Alexander Korotkov | 2018-09-27 20:31:24 | pgsql: Minor formatting cleanup for 2a6368343f |