MIME-Version: 1.0
In-Reply-To: <233968.1774445501@sss.pgh.pa.us>
References: <19437-0a65fb52d0f13a0d@postgresql.org> <233968.1774445501@sss.pgh.pa.us>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 25 Mar 2026 06:52:14 -0700
Message-ID: <CAKFQuwbtK=HfDsUo7p7zqFUb-h=ZqUS93K4+9nbOPW+bKnQuaA@mail.gmail.com>
Subject: BUG #19437: temp_tablespaces doesn't work inside a cursor?
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "kuzmin.db4@gmail.com" <kuzmin.db4@gmail.com>, 
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000004e0275064dd99336"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbtK%3DHfDsUo7p7zqFUb-h%3DZqUS93K4%2B9nbOPW%2BbKnQuaA%40mail.gmail.com>
Precedence: bulk

--0000000000004e0275064dd99336
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=99t changed during the sequence.

I haven=E2=80=99t tried to validate the cursor claim yet but; this definite=
ly isn=E2=80=99t
the easiest format to consume and I can=E2=80=99t do much on my own present=
ly.

David J.

--0000000000004e0275064dd99336
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wednesday, March 25, 2026, Tom Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa=
.us" target=3D"_blank">tgl@sss.pgh.pa.us</a>&gt; wrote:<br><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pad=
ding-left:1ex">PG Bug reporting form &lt;<a href=3D"mailto:noreply@postgres=
ql.org" target=3D"_blank">noreply@postgresql.org</a>&gt; writes:<br>
&gt; I&#39;m seeing strange behavior in Postgres when changing the temp_tab=
lespaces<br>
&gt; parameter and suspect a bug. At least, I haven&#39;t found a descripti=
on of this<br>
&gt; behavior in the documentation.<br>
<br>
I think you are imagining that pg_reload_conf() is a synchronous<br>
operation.</blockquote><div><br></div><div>The use of sleep does indicate a=
wareness of the async nature of this.=C2=A0</div><blockquote class=3D"gmail=
_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:=
1ex"><br></blockquote><blockquote class=3D"gmail_quote" style=3D"margin:0 0=
 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">&gt; Ensure that tempo=
rary files are created in it:<br></blockquote><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex=
">
&gt; \o /dev/null<br>
<br>
What does &quot;\o /dev/null&quot; have to do with this?=C2=A0 That&#39;s a=
<br>
psql-side operation.<br>
</blockquote><div><br></div><div>The comment applies to all three lines in =
the following block, not just the first line.</div><div><br></div><div>Ther=
e is something odd here.=C2=A0 Look at the log entry at 12:04:08.016; it us=
es base/ while the surrounding ones use pg_tblspace/ and the setting itself=
 hasn=E2=80=99t changed during the sequence.</div><div><br></div><div>I hav=
en=E2=80=99t tried to validate the cursor claim yet but; this definitely is=
n=E2=80=99t the easiest format to consume and I can=E2=80=99t do much on my=
 own presently.</div><div><br></div><div>David J.</div><div><br></div>

--0000000000004e0275064dd99336--