Re: COPY, lock release and MVCC - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: COPY, lock release and MVCC
Date
Msg-id 530ec640afd8e76b05ff270602e1f7048f1360e3.camel@cybertec.at
Whole thread Raw
In response to Re: COPY, lock release and MVCC  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: COPY, lock release and MVCC
List pgsql-hackers
On Mon, 2020-05-11 at 15:43 -0400, Robert Haas wrote:
> On Fri, May 8, 2020 at 4:58 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> > I happened to notice that COPY TO releases the ACCESS SHARE lock
> > on the table right when the command ends rather than holding it
> > until the end of the transaction:
> 
> That seems inconsistent with what an INSERT statement would do, and thus bad.

Well, should we fix the code or the documentation?

Yours,
Laurenz Albe




pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Our naming of wait events is a disaster.
Next
From: Tom Lane
Date:
Subject: Re: COPY, lock release and MVCC