pgsql: Make opr_sanity test complain about built-in functions marked pr

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Make opr_sanity test complain about built-in functions marked pr
Date: 2017-06-20 21:06:48
Message-ID: E1dNQMK-0003yp-Mf@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Make opr_sanity test complain about built-in functions marked prosecdef.

Currently, there are no built-in functions that are SECURITY DEFINER.
But we just found an instance where one was mistakenly marked that way,
so it seems prudent to add a test about it. If we ever grow some
functions that are intentionally SECURITY DEFINER, we can alter the
expected output of this test, or adjust the query to filter out functions
for which it's okay.

Per suggestion from Robert Haas.

Discussion: https://postgr.es/m/CA+TgmoYXg7McY33+jbWmG=rS-HNUur0S6W8Q8kVNFf7epFimVA@mail.gmail.com

Branch
------
master

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

Modified Files
--------------
src/test/regress/expected/opr_sanity.out | 10 ++++++++++
src/test/regress/sql/opr_sanity.sql | 7 +++++++
2 files changed, 17 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2017-06-21 08:55:58 pgsql: Fix typo in comment.
Previous Message Peter Eisentraut 2017-06-20 18:32:25 pgsql: Fix typo in code comment