Horton

Re: pg_ls_tmpdir()

Nathan Bossart <bossartn@amazon.com>

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

Attachments

On 10/2/18, 11:46 AM, "Tom Lane" <tgl@sss.pgh.pa.us> wrote:
> "Bossart, Nathan" <bossartn@amazon.com> writes:
>> On 10/2/18, 7:22 AM, "Andrew Dunstan" <andrew.dunstan@2ndquadrant.com> wrote:
>>> See the bottom of src/backend/catalog/system_views.sql starting around 
>>> line 1010.
>
>> AFAICT the cleanest way to do this in system_views.sql is to hard-code
>> the pg_default tablespace OID in the DEFAULT expression.  So, it might
>> be best to use the two function approach if we want pg_ls_tmpdir() to
>> default to the pg_default tablespace.
>
> That would be pretty bletcherous, so +1 for just making two C functions.

Alright, here's an updated patch.

Nathan

Commits

  1. Add pg_ls_tmpdir function