| From: | Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | What Causes Access Exclusive Lock? |
| Date: | 2016-06-22 17:06:03 |
| Message-ID: | CADp-Sm6LzXMmKRab0o37XH_27b6sXmUYv-BYfj6eyXckMK+P9Q@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 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2016-06-22 17:51:50 | Re: Protect a table against concurrent data changes while allowing to vacuum it |
| Previous Message | Melvin Davidson | 2016-06-22 16:39:16 | Re: Help on recovering my standby |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sameer Kumar | 2016-06-23 15:14:18 | What Causes Access Exclusive Lock? |
| Previous Message | Tom Lane | 2016-06-20 13:39:46 | Re: How to set lc_numeric in Postgres permanently for specific database? |