babelfish-for-postgresql / babelfish_extensions / 10247058665

74%

BABEL_5_X_DEV: 77%

push

github

Update views sys.triggers, sys.objects, sys.all_objects to show the correct object_id of trigger (#2830)

Show object_id of pg_trigger instead of pg_proc in the views sys.triggers, sys.events, sys.objects, sys.all_objects etc for triggers. It removes inconsistency of object_id between OBJECT_ID() and SYS views.

If the object type is specified as 'p' and it's actually a trigger, then object_id() should return NULL.

Issues Resolved: Task: BABEL-5108, BABEL-3927

Signed-off-by: Shalini Lohia lshalini@amazon.com

1 of 4 new or added lines in 1 file covered. (25.0%)

42483 of 57761 relevant lines covered (73.55%)

104872.37 hits per line