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. 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