venkatrao.b@tcs.com wrote:
> I need to find object dependencies in postgres 8.4 database. Mainly i am
> concerned about how functions are dependent(one function calling other
> one) of one another. In oracle, we have options of _dpendency views(
> user_dependecy,all_dependency and dba_dependecy).
> Is there any equivalent available in Postgres 8.4. I have seen pg_depend
> catalog, but I don't know, is this the one which i am looking for; also
> how to use this catalog (join with other catalogs ??).
> Can anyone kindly help me in this regard.
Dependencies between (non-SQL) functions and from (non-SQL)
functions on tables, views, etc. are neither automatically
discovered nor enforced (in the end that would be equivalent
to solving the halting problem anyway :-)).
I'd really like to see an option "DEPENDS ON <function,
table, view, etc.>" for "CREATE FUNCTION" to solve this in a
reasonable manner.
Tim