Re: Find out what on what function depends an index

Andreas Ulbrich <andreas.ulbrich@matheversum.de> writes:
> The question is the todo in the script: Is there a way to find out what
> indexes depends on what function?

Direct dependencies would show up in pg_depend.  Indirect ones wouldn't,
since we don't analyze function bodies to see what they call (and if we
tried, there's the little matter of the halting problem).

A larger problem is that frequently the real issue with an unstable index
expression definition is that it depends on context, such as GUC settings,
rather than the function body per se.  So I'm not sure how much pain you'd
really be able to prevent with this approach.

            regards, tom lane