Re: A table lock inside a transaction depends on query protocol being used?

From: Istvan Soos <istvan(dot)soos(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: A table lock inside a transaction depends on query protocol being used?
Date: 2024-11-20 19:39:44
Message-ID: CALdQGgtRqNFnwEC7SEQQhZmbEdUJ2W+v-m-vrhoyo=SHUEW_rQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 20, 2024 at 7:57 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Mullineux 2024-11-20 22:10:40 Re: Memory settings when running postgres in a docker container
Previous Message Tom Lane 2024-11-20 18:57:57 Re: A table lock inside a transaction depends on query protocol being used?