MIME-Version: 1.0
References: <CAEzk6ff5yHiJWDCoLcmqwC36O=VqLEHjbU2pcpYpOvdScM3t5g@mail.gmail.com>
 <b5778c67-0a7a-4da8-bc17-e4343b2b10cb@aklaver.com> <CAEzk6ffsg4imcsreOF=NASsktRdYWNXUWJFb2KK_eJHs=BmTKQ@mail.gmail.com>
In-Reply-To: <CAEzk6ffsg4imcsreOF=NASsktRdYWNXUWJFb2KK_eJHs=BmTKQ@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Fri, 6 Feb 2026 14:34:56 -0500
Message-ID: <CAKAnmmKynqFFhvrEqqXv=yVGtip+kG6mkg3TZ7Z9DKO5JpNZ5w@mail.gmail.com>
Subject: Re: 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="0000000000005d391d064a2ce42d"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmKynqFFhvrEqqXv%3DyVGtip%2BkG6mkg3TZ7Z9DKO5JpNZ5w%40mail.gmail.com>
Precedence: bulk

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

On Fri, Feb 6, 2026 at 11:56=E2=80=AFAM Geoff Winkless <pg@ukku.uk> wrote:

> I'm fully prepared to accept that I'm doing something wrong because I've
> tried to reproduce the error using a couple of test PHP processes
> with a socket between them and haven't managed to reproduce the failure i=
n
> several million tries, but I'm at a loss as to what to look
> for, so any suggestion would be gratefully accepted.
>

Temporarily set log_statement =3D 'all', then parse through the logs to fin=
d
the error, and look around it to see when the table was created.

Cheers,
Greg

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

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Feb 6, 2026 at 11:56=E2=80=AFAM G=
eoff Winkless &lt;<a href=3D"mailto:pg@ukku.uk">pg@ukku.uk</a>&gt; wrote:</=
div><div class=3D"gmail_quote gmail_quote_container"><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex">I&#39;m fully prepared to accept that I&#39;m d=
oing something wrong because I&#39;ve tried to reproduce the error using a =
couple of test PHP processes<br>
with a socket between them and haven&#39;t managed to reproduce the failure=
 in several million tries, but I&#39;m at a loss as to what to look<br>
for, so any suggestion would be gratefully accepted.<br></blockquote><div><=
br></div><div>Temporarily set log_statement =3D &#39;all&#39;, then parse t=
hrough the logs to find the error, and look around it to see when the table=
 was created.</div><div><br></div><div>Cheers,</div></div><div dir=3D"ltr" =
class=3D"gmail_signature"><div dir=3D"ltr"><div>Greg</div><div><br></div></=
div></div></div>

--0000000000005d391d064a2ce42d--