postgres - What could be the dependent objects for a trigger

Question

Could anyone explain what objects could possibly depend on a trigger in postgres. Below is the syntax for drop trigger: DROP TRIGGER [ IF EXISTS ] name ON table [ CASCADE | RESTRICT ]

Casdcade/Restrict here impact the dependent objects of a trigger.

I tried creating triggers but failed to see objects that depends on a trigger. Always I see trigger is dependent on other objects such as function, table column but not vice versa.

Can anyone tell me what objects could possibly depend on triggers. Am going to use Cascade option in drop trigger syntax and like to know what kind of object will get impacted.

Thanks, Vaish

Answer 1

You can either use pgAdmin to check the dependents/dependencies (just click the object and select the wanted tab in the view)

or

use \d+ XXXX on the commandline to see what might depend on it