diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2016-11-25 13:44:47 -0500 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2016-11-25 13:44:47 -0500 |
commit | bf5fe7bfa0e8bdc87be94b98bbdcb26054a6b75c (patch) | |
tree | aeff13547d034af4940b2858d633b2f1678d7011 /src/backend/access/transam/xlog.c | |
parent | 81f92a55c7bb920a7b915ae0e022a8488126ec22 (diff) | |
download | postgresql-bf5fe7bfa0e8bdc87be94b98bbdcb26054a6b75c.tar.gz postgresql-bf5fe7bfa0e8bdc87be94b98bbdcb26054a6b75c.zip |
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/backend/access/transam/xlog.c')
0 files changed, 0 insertions, 0 deletions