From: | Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Access Exclusive Lock |
Date: | 2016-06-20 12:57:08 |
Message-ID: | CADp-Sm5O55vNpkiNXkPf1L_sqz95gLbiaWYoWQOsvz0Y8zQrhw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general 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
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
From | Date | Subject | |
---|---|---|---|
Next Message | Adarsh Sharma | 2016-06-20 13:11:27 | Re: R: Vacuum full: alternatives? |
Previous Message | Melvin Davidson | 2016-06-20 12:50:35 | Re: R: Vacuum full: alternatives? |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-06-20 13:39:46 | Re: How to set lc_numeric in Postgres permanently for specific database? |
Previous Message | szyk100 | 2016-06-20 11:26:05 | How to set lc_numeric in Postgres permanently for specific database? |