Postgres Pro
Downloads
Home   >   mailing lists

Re: How to explicitly lock and unlock tables in pgsql? - Mailing list pgsql-general

From Fabrízio de Royes Mello
Subject Re: How to explicitly lock and unlock tables in pgsql?
Date
Msg-id CAPfkCSD+rbeZW6QKR_mhmTRqOOSd06eq+LfpDJiaMYt8LqAhVg@mail.gmail.com
Whole thread Raw
In response to How to explicitly lock and unlock tables in pgsql?  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-general
Tree view

Em qua., 16 de mar. de 2022 às 17:30, Shaozhong SHI <shishaozhong@gmail.com> escreveu:
Table locks present a barrier for progressing queries.

How to explicitly lock and unlock tables in pgsql, so that we can guarantee the progress of running scripts?

Regards,

David 

Have a look at https://www.postgresql.org/docs/current/sql-lock.html

--

pgsql-general by date:

Previous
From: Shaozhong SHI
Date:
Subject: How to explicitly lock and unlock tables in pgsql?
Next
From: Laurenz Albe
Date:
Subject: Re: How to explicitly lock and unlock tables in pgsql?