From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Reduce lock levels of some trigger DDL and add FKs |
Date: | 2015-04-05 15:46:29 |
Message-ID: | E1Yemkn-0002qK-EM@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Reduce lock levels of some trigger DDL and add FKs
Reduce lock levels to ShareRowExclusive for the following SQL
CREATE TRIGGER (but not DROP or ALTER)
ALTER TABLE ENABLE TRIGGER
ALTER TABLE DISABLE TRIGGER
ALTER TABLE … ADD CONSTRAINT FOREIGN KEY
Original work by Simon Riggs, extracted and refreshed by Andreas Karlsson
New test cases added by Andreas Karlsson
Reviewed by Noah Misch, Andres Freund, Michael Paquier and Simon Riggs
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/0ef0396ae1687bf738d4703773d55467c36b2bcd
Modified Files
--------------
doc/src/sgml/mvcc.sgml | 12 +-
doc/src/sgml/ref/alter_table.sgml | 3 +
src/backend/commands/tablecmds.c | 35 +-
src/backend/commands/trigger.c | 4 +-
src/test/isolation/expected/alter-table-1.out | 1646 ++++++++++++++++++-------
src/test/isolation/isolation_schedule | 3 +
src/test/regress/expected/alter_table.out | 22 +-
7 files changed, 1236 insertions(+), 489 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2015-04-05 15:52:26 | pgsql: Enable float8-byval as the default for 64 bit MSVC builds |
Previous Message | Tom Lane | 2015-04-04 23:55:58 | pgsql: Fix incorrect matching of subexpressions in outer-join plan node |