pgsql: Add relkind checks to certain contrib modules

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add relkind checks to certain contrib modules
Date: 2017-03-09 21:34:41
Message-ID: E1cm5hp-00037A-UQ@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add relkind checks to certain contrib modules

The contrib extensions pageinspect, pg_visibility and pgstattuple only
work against regular relations which have storage. They don't work
against foreign tables, partitioned (parent) tables, views, et al.

Add checks to the user-callable functions to return a useful error
message to the user if they mistakenly pass an invalid relation to a
function which doesn't accept that kind of relation.

In passing, improve some of the existing checks to use ereport() instead
of elog(), add a function to consolidate common checks where
appropriate, and add some regression tests.

Author: Amit Langote, with various changes by me
Reviewed by: Michael Paquier and Corey Huinker
Discussion: https://postgr.es/m/ab91fd9d-4751-ee77-c87b-4dd704c1e59c@lab.ntt.co.jp

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c08d82f38ebf763b79bd43ae34b7310ee47aaacd

Modified Files
--------------
contrib/pageinspect/expected/page.out | 9 ++
contrib/pageinspect/rawpage.c | 5 +
contrib/pageinspect/sql/page.sql | 9 ++
contrib/pg_visibility/.gitignore | 4 +
contrib/pg_visibility/Makefile | 2 +
contrib/pg_visibility/expected/pg_visibility.out | 142 +++++++++++++++++++++++
contrib/pg_visibility/pg_visibility.c | 58 ++++++---
contrib/pg_visibility/sql/pg_visibility.sql | 83 +++++++++++++
contrib/pgstattuple/expected/pgstattuple.out | 107 +++++++++++++++++
contrib/pgstattuple/pgstatindex.c | 52 +++++++--
contrib/pgstattuple/pgstattuple.c | 3 +
contrib/pgstattuple/sql/pgstattuple.sql | 64 ++++++++++
12 files changed, 517 insertions(+), 21 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2017-03-09 22:20:43 pgsql: Fix timestamptz regression test to still work with latest IANA z
Previous Message Robert Haas 2017-03-09 18:14:03 pgsql: Document lack of validation when attaching foreign partitions.