MIME-Version: 1.0
In-Reply-To: <CAEzk6ffsg4imcsreOF=NASsktRdYWNXUWJFb2KK_eJHs=BmTKQ@mail.gmail.com>
References: <CAEzk6ff5yHiJWDCoLcmqwC36O=VqLEHjbU2pcpYpOvdScM3t5g@mail.gmail.com>
 <b5778c67-0a7a-4da8-bc17-e4343b2b10cb@aklaver.com> <CAEzk6ffsg4imcsreOF=NASsktRdYWNXUWJFb2KK_eJHs=BmTKQ@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 6 Feb 2026 09:34:13 -0800
Message-ID: <CAKFQuwbuzBR3Z2qe+4SSeA+31Wo5LYQvgMy4TrAQF212BQs1Yg@mail.gmail.com>
Subject: UNLOGGED table CREATEd on one connection not immediately visible to
 another connection
To: Geoff Winkless <pg@ukku.uk>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000aab227064a2b320d"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwbuzBR3Z2qe%2B4SSeA%2B31Wo5LYQvgMy4TrAQF212BQs1Yg%40mail.gmail.com>
Precedence: bulk

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

On Friday, February 6, 2026, Geoff Winkless <pg@ukku.uk> wrote:
>
>
> I can't provide the entire code, because it's not open. It's using
> libpq and our own wrapper around PQsendQuery that handles things like
> autoretries, auto-reconnection and grabbing all results to ensure the
> connection is kept in a consistent state.


Have you investigated schema and search_path interactions?

Do you have a reproducer on your end, can try different versions of
PostgreSQL to see if it is a regression?  Or to then remove components to
isolate a middleware dynamic.  We=E2=80=99d probably need a reproducer with=
out any
customizations to begin debugging core.

What version are you on?

David J.

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

On Friday, February 6, 2026, Geoff Winkless &lt;<a href=3D"mailto:pg@ukku.u=
k" target=3D"_blank">pg@ukku.uk</a>&gt; wrote:<blockquote class=3D"gmail_qu=
ote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex=
">
<br>
I can&#39;t provide the entire code, because it&#39;s not open. It&#39;s us=
ing<br>
libpq and our own wrapper around PQsendQuery that handles things like<br>
autoretries, auto-reconnection and grabbing all results to ensure the<br>
connection is kept in a consistent state.</blockquote><div><br></div><div>H=
ave you investigated schema and search_path interactions?</div><div><br></d=
iv><div>Do you have a reproducer on your end, can try different versions of=
 PostgreSQL to see if it is a regression?=C2=A0 Or to then remove component=
s to isolate a middleware dynamic.=C2=A0 We=E2=80=99d probably need a repro=
ducer without any customizations to begin debugging core.</div><div><br></d=
iv><div>What version are you on?</div><div><br></div><div>David J.</div><di=
v><br></div>

--000000000000aab227064a2b320d--