Re: How to explicitly lock and unlock tables in pgsql?

Поиск

Список

Период

Сортировка

От	Fabrízio de Royes Mello
Тема	Re: How to explicitly lock and unlock tables in pgsql?
Дата	16 марта 2022 г. 23:35:48
Msg-id	CAPfkCSD+rbeZW6QKR_mhmTRqOOSd06eq+LfpDJiaMYt8LqAhVg@mail.gmail.com обсуждение исходный текст
Ответ на	How to explicitly lock and unlock tables in pgsql? (Shaozhong SHI <shishaozhong@gmail.com>)
Список	pgsql-general

Дерево обсуждения

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