Re: [BUGS] pg_get_functiondef() does not show LEAKPROOF for leakproof functions - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [BUGS] pg_get_functiondef() does not show LEAKPROOF for leakproof functions
Date
Msg-id CAB7nPqT8RueHHDEHpbtqMxG8cEC4aogWNUNb9+aroLhQPX1bMg@mail.gmail.com
Whole thread Raw
In response to pg_get_functiondef() does not show LEAKPROOF for leakproof functions  (Jeevan Chalke <jeevan.chalke@enterprisedb.com>)
Responses Re: [BUGS] pg_get_functiondef() does not show LEAKPROOF for leakproof functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, May 28, 2015 at 5:52 PM, Jeevan Chalke
<jeevan.chalke@enterprisedb.com> wrote:
> If function is created with the LEAKPROOF option, then pg_get_functiondef()
> does not show that in the returned definition.
> Is it expected OR are we missing that option in pg_get_functiondef().
>
> However only superuser can define a leakproof function.
> Was this the reason we are not showing that in pg_get_functiondef() output?>
> I don't think we should hide this detail.

Agreed. I guess that it has been simply forgotten. pg_proc can be
easily queried, so functions marked as leakproof are easy to find out
in any case.
-- 
Michael



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Memory leak with XLogFileCopy since de768844 (WAL file with .partial)
Next
From: Robert Haas
Date:
Subject: Re: Re: [GENERAL] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1