summaryrefslogtreecommitdiff
path: root/src/interfaces
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2016-11-25 13:44:48 -0500
committerTom Lane <tgl@sss.pgh.pa.us>2016-11-25 13:44:48 -0500
commitf7166ce243aec3f5df454377d81b67032d85f35c (patch)
treea51c6f53e94cbe14170c3505fde05e3046ef6834 /src/interfaces
parent15f3e0cb13e7711195915996664e0b035c0498f9 (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 'src/interfaces')
0 files changed, 0 insertions, 0 deletions