From: Tom Lane <tgl@sss.pgh.pa.us>
To: Shaozhong SHI <shishaozhong@gmail.com>
cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Subject: Re: How to explicitly state unlock in sql?
In-reply-to: 
 <CA+i5JwYb8cKEk818-TvinOzEdB5dswBo+n8CjxmPOo=Mivt4mw@mail.gmail.com>
References: 
 <CA+i5JwYb8cKEk818-TvinOzEdB5dswBo+n8CjxmPOo=Mivt4mw@mail.gmail.com>
Comments: In-reply-to Shaozhong SHI <shishaozhong@gmail.com>
	message dated "Wed, 16 Mar 2022 20:56:47 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <677228.1647464794.1@sss.pgh.pa.us>
Date: Wed, 16 Mar 2022 17:06:34 -0400
Message-ID: <677229.1647464794@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/677229.1647464794%40sss.pgh.pa.us>
Precedence: bulk

Shaozhong SHI <shishaozhong@gmail.com> writes:
> Locked tables stop progress.
> How to explicitly preventing locking?

You are really wasting everybody's time, including yours,
with these detail-free questions.  The short answer to the
question as stated is "you can't".  There is probably some
more-useful answer that could be given, but we'd need to
understand a lot more about what your actual problem is.

There is some advice about how to ask useful questions at

https://wiki.postgresql.org/wiki/Guide_to_reporting_problems

			regards, tom lane