Postgres Pro
Downloads
Home   >   mailing lists

Table Truncate and Locks - Mailing list pgsql-admin

From Chris Hoover
Subject Table Truncate and Locks
Date
Msg-id 1d219a6f0609280810j5e156f33uaafbb37c17ee5d5d@mail.gmail.com
Whole thread Raw
Responses SELECT FOR UPDATE NOWAIT  ("Mathias Laurent" <e1lauren@hotmail.com>)
List pgsql-admin
Tree view
What sort of lock does truncate require?  If it is not an access exclusive lock, what locks would block the truncate?

Thanks,

Chris

pgsql-admin by date:

Previous
From: Chan Michael
Date:
Subject: How can I restore from WAL log? [PG 7.3]
Next
From: "Mathias Laurent"
Date:
Subject: SELECT FOR UPDATE NOWAIT