Re: pg_ls_tmpdir() - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_ls_tmpdir()
Date
Msg-id 26978.1538498802@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_ls_tmpdir()  ("Bossart, Nathan" <bossartn@amazon.com>)
Responses Re: pg_ls_tmpdir()  ("Bossart, Nathan" <bossartn@amazon.com>)
List pgsql-hackers
"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.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: has_column_privilege behavior (was Re: Assert failed in snprintf.c)
Next
From: Merlin Moncure
Date:
Subject: Re: transction_timestamp() inside of procedures