Home > mailing lists

Access Exclusive Lock - Mailing list pgsql-novice

From	Sameer Kumar
Subject	Access Exclusive Lock
Date	June 20, 2016 15:57:29
Msg-id	CADp-Sm5O55vNpkiNXkPf1L_sqz95gLbiaWYoWQOsvz0Y8zQrhw@mail.gmail.com Whole thread Raw
Responses	What Causes Access Exclusive Lock? (Sameer Kumar <sameer.kumar@ashnik.com>)
List	pgsql-novice

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

From: szyk100
Date: 20 June 2016, 14:26:13
Subject: How to set lc_numeric in Postgres permanently for specific database?

From: Tom Lane
Date: 20 June 2016, 16:40:10
Subject: Re: How to set lc_numeric in Postgres permanently for specific database?