babelfish-for-postgresql / babelfish_extensions / 10251265732

76%

BABEL_5_X_DEV: 77%

push

github

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

* 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

* Update upgrade script

---------

Signed-off-by: Shalini Lohia lshalini@amazon.com
Co-authored-by: Shalini Lohia <lshalini@amazon.com>

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

43962 of 59729 relevant lines covered (73.6%)

120255.08 hits per line