On 06/23/2016 08:14 AM, Sameer Kumar wrote:
Hi, I just wanted to understand what are the commands which will acquire Access Exclusive Lock on a table? In my knowledge below operations will acquire access exclusive lock:- 1. VACUUM FULL 2. ALTER TABLE 3. DROP TABLE 4. TRUNCATE 5. REINDEX 6. LOCK command with Access Exclusive Mode (or no mode specified) I am using PostgreSQL v9.4.
https://www.postgresql.org/docs/9.4/static/explicit-locking.html ACCESS EXCLUSIVE
Regards Sameer -- -- Best Regards Sameer Kumar | DB Solution Architect *ASHNIK PTE. LTD.* 101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533 T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
