MIME-Version: 1.0
References: <19437-0a65fb52d0f13a0d@postgresql.org> <233968.1774445501@sss.pgh.pa.us>
 <CAKFQuwbtK=HfDsUo7p7zqFUb-h=ZqUS93K4+9nbOPW+bKnQuaA@mail.gmail.com>
In-Reply-To: <CAKFQuwbtK=HfDsUo7p7zqFUb-h=ZqUS93K4+9nbOPW+bKnQuaA@mail.gmail.com>
From: Dmitriy Kuzmin <kuzmin.db4@gmail.com>
Date: Mon, 6 Apr 2026 11:16:19 +1000
Message-ID: <CAHLDt=-HP4V8rfxEWE6-xC93YTN2X=KNeyYZsygVqnb-adRe6g@mail.gmail.com>
Subject: Re: BUG #19437: temp_tablespaces doesn't work inside a cursor?
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, 
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000a8d9a2064ec06ab2"
Archived-At: <https://www.postgresql.org/message-id/CAHLDt%3D-HP4V8rfxEWE6-xC93YTN2X%3DKNeyYZsygVqnb-adRe6g%40mail.gmail.com>
Precedence: bulk

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

Hello!

Any news on these issues?
Let me know if the provided information isn't enough to reproduce them

Best regards, Dmitry Kuzmin

=D1=81=D1=80, 25 =D0=BC=D0=B0=D1=80. 2026=E2=80=AF=D0=B3. =D0=B2 23:52, Dav=
id G. Johnston <david.g.johnston@gmail.com>:

> 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 o=
f
>> 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 defini=
tely
> isn=E2=80=99t the easiest format to consume and I can=E2=80=99t do much o=
n my own presently.
>
> David J.
>
>

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

<div dir=3D"ltr">Hello!<br><br>Any news on these issues?<br>Let me know if =
the provided information isn&#39;t enough to reproduce them<br><div><br></d=
iv><div>Best regards, Dmitry Kuzmin<br></div></div><br><div class=3D"gmail_=
quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">=D1=81=
=D1=80, 25 =D0=BC=D0=B0=D1=80. 2026=E2=80=AF=D0=B3. =D0=B2 23:52, David G. =
Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail.com">david.g.johnston=
@gmail.com</a>&gt;:<br></div><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1=
ex">On Wednesday, March 25, 2026, Tom Lane &lt;<a href=3D"mailto:tgl@sss.pg=
h.pa.us" target=3D"_blank">tgl@sss.pgh.pa.us</a>&gt; wrote:<br><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex">PG Bug reporting form &lt;<a href=3D"=
mailto:noreply@postgresql.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:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204=
,204);padding-left:1ex"><br></blockquote><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pa=
dding-left:1ex">&gt; Ensure that temporary files are created in it:<br></bl=
ockquote><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid rgb(204,204,204);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>
</blockquote></div>

--000000000000a8d9a2064ec06ab2--