Re: What Causes Access Exclusive Lock?

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@aklaver.com