Home > mailing lists

Apparently table locks are the key issue to see red flags - Mailing list pgsql-sql

From	Shaozhong SHI
Subject	Apparently table locks are the key issue to see red flags
Date	March 16, 2022 23:14:43
Msg-id	CA+i5JwaXPHh8pOCvN8w0MQiQmz5RMZnsieLCDA-Di2QjZ=hWfQ@mail.gmail.com Whole thread Raw
List	pgsql-sql

Apparently table locks are the key issue to see red flags.

As we observe, every time, red marking occurs, there must be some tables are locked.

Can anyone shed light into this?

Regards,

David

From: Sebastien Flaesch
Date: 09 March 2022, 11:26:30
Subject: Re: Best practice for naming temp table trigger functions

From: Shaozhong SHI
Date: 16 March 2022, 23:30:54
Subject: How to explicitly lock and unlock tables in pgsql?