diff options
| author | Tom Lane | 2016-11-25 18:44:48 +0000 |
|---|---|---|
| committer | Tom Lane | 2016-11-25 18:44:48 +0000 |
| commit | 6a363a4c252329f1f97d80526eb55b3301abf1f2 (patch) | |
| tree | 2e6e98203a6db6ad193715400433a48caae25d18 /doc/src | |
| parent | 05975ab0a62ce86c49dd607600148fba5c79c549 (diff) | |
Check for pending trigger events on far end when dropping an FK constraint.
When dropping a foreign key constraint with ALTER TABLE DROP CONSTRAINT,
we refuse the drop if there are any pending trigger events on the named
table; this ensures that we won't remove the pg_trigger row that will be
consulted by those events. But we should make the same check for the
referenced relation, else we might remove a due-to-be-referenced pg_trigger
row for that relation too, resulting in "could not find trigger NNN" or
"relation NNN has no triggers" errors at commit. Per bug #14431 from
Benjie Gillam. Back-patch to all supported branches.
Report: <20161124114911.6530.31200@wrigleys.postgresql.org>
Diffstat (limited to 'doc/src')
0 files changed, 0 insertions, 0 deletions
