On 10/02/2018 08:00 AM, Laurenz Albe wrote:
> Christoph Berg wrote:
>> Re: Bossart, Nathan 2018-10-01 <69FD7E51-2B13-41FD-9438-17395C73F5BF@amazon.com>
>>>> 1. Do we really need two functions, one without input argument
>>>> to list the default tablespace?
>>>> I think that anybody who uses with such a function whould
>>>> be able to feed the OID of "pg_default".
>>> That seems reasonable to me. I've removed the second version of the
>>> function.
>> You could make that one argument have a DEFAULT value that makes it
>> act on pg_default.
> I looked at that, and I don't think you can add a DEFAULT for
> system functions installed during bootstrap.
> At least I failed in the attempt.
See the bottom of src/backend/catalog/system_views.sql starting around
line 1010.
cheers
andrew
--
Andrew Dunstan https://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services