Horton

Re: pg_ls_tmpdir()

Andrew Dunstan <andrew.dunstan@2ndquadrant.com>

View thread View on postgr.es
From: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>, Christoph Berg <myon@debian.org>, "Bossart, Nathan" <bossartn@amazon.com>
Cc: Andres Freund <andres@anarazel.de>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2018-10-02T12:21:30Z
Lists: pgsql-hackers 

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

Commits

  1. Add pg_ls_tmpdir function