babelfish-for-postgresql / babelfish_extensions / 12391500641

74%

BABEL_5_X_DEV: 77%

push

github

Fix alter table drop column drops trigger on the table (#3225) (#3277)

In postgres trigger and functions are two different objects. You first define a function and then use it in your trigger definition. In babelfish we handle this internally so that for users it feels like a single object. As part of this internal handing we also drop the function created for this trigger as part of post object access hook. Currently the condition for DROP TABLE was incomplete and even for DROP COLUMN we would drop the triggers associated with the table.
As a fix add another condition to only execute this internal drop of triggers for DROP TABLE.

Issues Resolved: BABEL-5417
Signed-off-by: Tanzeel Khan <tzlkhan@amazon.com>

1 of 1 new or added line in 1 file covered. (100.0%)

43105 of 58423 relevant lines covered (73.78%)

147818.68 hits per line