Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

[NOVICE] Access Exclusive Lock

1 view

Skip to first unread message

unread,

Jun 20, 2016, 8:58:31 AM6/20/16

Hi,

I just wanted to understand what are the various commands which will acquire Access Exclusive Lock on a table? In my knowledge-

1. VACUUM FULL

2. ALTER TABLE

3. DROP TABLE

4. TRUNCATE

5. REINDEX

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

0 new messages