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

From Tom Lane
Subject Re: [BUGS] pg_get_functiondef() does not show LEAKPROOF for leakproof functions
Date
Msg-id 10877.1432822684@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] pg_get_functiondef() does not show LEAKPROOF for leakproof functions  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Michael Paquier <michael.paquier@gmail.com> writes:
> 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().

> 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.

Looks like a clear oversight to me.  I had first thought that this might
have been intentional because pg_dump needed it to act like that --- but
pg_dump doesn't use pg_get_functiondef.  I think it was simply forgotten.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [Proposal] More Vacuum Statistics
Next
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade resets timeline to 1