Skip site navigation (1)
Skip section navigation (2)
What sort of lock does truncate require? If it is not an access exclusive lock, what locks would block the truncate?
Thanks,
Chris
Peripheral Links
Header And Logo
|
Site Navigation
Table Truncate and Locks
- From: "Chris Hoover" <revoohc(at)gmail(dot)com>
- To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
- Subject: Table Truncate and Locks
- Date: Thu, 28 Sep 2006 11:10:46 -0400
What sort of lock does truncate require? If it is not an access exclusive lock, what locks would block the truncate?
Thanks,
Chris
- Follow-Ups:
- SELECT FOR UPDATE NOWAIT
- From: Mathias Laurent
- SELECT FOR UPDATE NOWAIT
- Prev by Date: How can I restore from WAL log? [PG 7.3]
- Next by Date: SELECT FOR UPDATE NOWAIT
- Previous by thread: How can I restore from WAL log? [PG 7.3]
- Next by thread: SELECT FOR UPDATE NOWAIT
- Indexes: