Thread: How to find object dependencies in PG 8.4

=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you

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