Andreas Ulbrich <andreas.ulbrich@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
