Request a Demo
Home   >   mailing lists

Re: UNLOGGED table CREATEd on one connection not immediately visible to another connection - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: UNLOGGED table CREATEd on one connection not immediately visible to another connection
Date
Msg-id CAKAnmmKynqFFhvrEqqXv=yVGtip+kG6mkg3TZ7Z9DKO5JpNZ5w@mail.gmail.com
Whole thread
In response to Re: UNLOGGED table CREATEd on one connection not immediately visible to another connection  (Geoff Winkless <pg@ukku.uk>)
List pgsql-general
Tree view
On Fri, Feb 6, 2026 at 11:56 AM 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 in 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 = 'all', then parse through the logs to find the error, and look around it to see when the table was created.

Cheers,
Greg

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: UNLOGGED table CREATEd on one connection not immediately visible to another connection
Next
From: Durgamahesh Manne
Date:
Subject: Table bloat threshold limit to trigger repack