]> granicus.if.org Git - postgresql/commit
Make opr_sanity test complain about built-in functions marked prosecdef.
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 20 Jun 2017 21:06:43 +0000 (17:06 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 20 Jun 2017 21:06:43 +0000 (17:06 -0400)
commitd412f79381935186dc8f95fd2dc30227a82f012f
tree0b9f0cd5ac2c5d00c58a9296dbf4c255ac545724
parent15c91568cfa4777892207a85000fdfd72b59b677
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
src/test/regress/expected/opr_sanity.out
src/test/regress/sql/opr_sanity.sql