Reduce lock levels of some trigger DDL and add FKs

Enterprise / PostgreSQL - Simon Riggs [2ndQuadrant.com] - 5 April 2015 10:37 UTC

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

0ef0396 Reduce lock levels of some trigger DDL and add FKs
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(-)

Upstream: git.postgresql.org

  • Share