BUG #19437: temp_tablespaces doesn't work inside a cursor? - Mailing list pgsql-bugs

From David G. Johnston
Subject BUG #19437: temp_tablespaces doesn't work inside a cursor?
Date
Msg-id CAKFQuwbtK=HfDsUo7p7zqFUb-h=ZqUS93K4+9nbOPW+bKnQuaA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #19437: temp_tablespaces doesn't work inside a cursor?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #19437: temp_tablespaces doesn't work inside a cursor?
Re: BUG #19437: temp_tablespaces doesn't work inside a cursor?
List pgsql-bugs
On Wednesday, March 25, 2026, Tom Lane <tgl@sss.pgh.pa.us> wrote:
PG Bug reporting form <noreply@postgresql.org> writes:
> I'm seeing strange behavior in Postgres when changing the temp_tablespaces
> parameter and suspect a bug. At least, I haven't found a description of this
> behavior in the documentation.

I think you are imagining that pg_reload_conf() is a synchronous
operation.

The use of sleep does indicate awareness of the async nature of this. 

> Ensure that temporary files are created in it:
> \o /dev/null

What does "\o /dev/null" have to do with this?  That's a
psql-side operation.

The comment applies to all three lines in the following block, not just the first line.

There is something odd here.  Look at the log entry at 12:04:08.016; it uses base/ while the surrounding ones use pg_tblspace/ and the setting itself hasn’t changed during the sequence.

I haven’t tried to validate the cursor claim yet but; this definitely isn’t the easiest format to consume and I can’t do much on my own presently.

David J.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #19437: temp_tablespaces doesn't work inside a cursor?
Next
From: PG Bug reporting form
Date:
Subject: BUG #19439: pg_stat_xact_user_tables stat not currect during the transaction