Postgres Pro
Downloads
Home   >   mailing lists

Re: A table lock inside a transaction depends on query protocol being used? - Mailing list pgsql-general

From Istvan Soos
Subject Re: A table lock inside a transaction depends on query protocol being used?
Date
Msg-id CALdQGgtRqNFnwEC7SEQQhZmbEdUJ2W+v-m-vrhoyo=SHUEW_rQ@mail.gmail.com
Whole thread Raw
In response to Re: A table lock inside a transaction depends on query protocol being used?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On Wed, Nov 20, 2024 at 7:57 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> but I wonder if you could be failing to close out the SELECT statement before issuing ALTER.

Thanks! This led me to check some debug details, and in fact we don't
close the portal, only the statement. (Besides a bug in the debug
log...)

Now I know what to fix :).

Thanks,
  Istvan

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: A table lock inside a transaction depends on query protocol being used?
Next
From: David Mullineux
Date:
Subject: Re: Memory settings when running postgres in a docker container