diff options
| author | Simon Riggs <simon@2ndQuadrant.com> | 2010-07-28 05:22:24 +0000 |
|---|---|---|
| committer | Simon Riggs <simon@2ndQuadrant.com> | 2010-07-28 05:22:24 +0000 |
| commit | 2dbbda02e7e688311e161a912a0ce00cde9bb6fc (patch) | |
| tree | adf4f2ca8c477550f19bd6362d0b6fa4ae19f68b /src/backend/utils/adt/ri_triggers.c | |
| parent | 133924e13e004db8979424bf5436e21b0a09a069 (diff) | |
| download | postgresql-2dbbda02e7e688311e161a912a0ce00cde9bb6fc.tar.gz postgresql-2dbbda02e7e688311e161a912a0ce00cde9bb6fc.zip | |
Reduce lock levels of CREATE TRIGGER and some ALTER TABLE, CREATE RULE actions.
Avoid hard-coding lockmode used for many altering DDL commands, allowing easier
future changes of lock levels. Implementation of initial analysis on DDL
sub-commands, so that many lock levels are now at ShareUpdateExclusiveLock or
ShareRowExclusiveLock, allowing certain DDL not to block reads/writes.
First of number of planned changes in this area; additional docs required
when full project complete.
Diffstat (limited to 'src/backend/utils/adt/ri_triggers.c')
| -rw-r--r-- | src/backend/utils/adt/ri_triggers.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backend/utils/adt/ri_triggers.c b/src/backend/utils/adt/ri_triggers.c index 080cb9c1ac2..14d183d2a51 100644 --- a/src/backend/utils/adt/ri_triggers.c +++ b/src/backend/utils/adt/ri_triggers.c @@ -15,7 +15,7 @@ * * Portions Copyright (c) 1996-2010, PostgreSQL Global Development Group * - * $PostgreSQL: pgsql/src/backend/utils/adt/ri_triggers.c,v 1.119 2010/07/22 00:47:52 rhaas Exp $ + * $PostgreSQL: pgsql/src/backend/utils/adt/ri_triggers.c,v 1.120 2010/07/28 05:22:24 sriggs Exp $ * * ---------- */ @@ -2608,7 +2608,7 @@ RI_FKey_keyequal_upd_fk(Trigger *trigger, Relation fk_rel, * This is not a trigger procedure, but is called during ALTER TABLE * ADD FOREIGN KEY to validate the initial table contents. * - * We expect that an exclusive lock has been taken on rel and pkrel; + * We expect that a ShareRowExclusiveLock or higher has been taken on rel and pkrel; * hence, we do not need to lock individual rows for the check. * * If the check fails because the current user doesn't have permissions |