Postgres Pro
Downloads
Home   >   mailing lists

What Causes Access Exclusive Lock? - Mailing list pgsql-novice

From Sameer Kumar
Subject What Causes Access Exclusive Lock?
Date
Msg-id CADp-Sm6LzXMmKRab0o37XH_27b6sXmUYv-BYfj6eyXckMK+P9Q@mail.gmail.com
Whole thread Raw
In response to Access Exclusive Lock  (Sameer Kumar <sameer.kumar@ashnik.com>)
List pgsql-novice
Tree view
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

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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to set lc_numeric in Postgres permanently for specific database?
Next
From: marc rassbach
Date:
Subject: failing to make LATIN1 on locale C system - what am I doing wrong?