Michael Fuhr wrote:
On Thu, Apr 06, 2006 at 03:36:33PM -0400, Emi Lu wrote:
How to check whether a table is locked?
You can monitor locks by querying the pg_locks view.
http://www.postgresql.org/docs/8.0/interactive/monitoring-locks.html
http://www.postgresql.org/docs/8.0/interactive/view-pg-
On Thu, Apr 06, 2006 at 03:36:33PM -0400, Emi Lu wrote:
> How to check whether a table is locked?
You can monitor locks by querying the pg_locks view.
http://www.postgresql.org/docs/8.0/interactive/monitoring-locks.html
http://www.postgresql.org/docs/8.0/interactive/view-pg-locks.html
Only a few
Hello,
How to check whether a table is locked? Is there a way that I can find
all deadlocks under postgresql 8.0.1 ?
Thanks alot!
Ying Lu
---(end of broadcast)---
TIP 6: explain analyze is your friend
