Обсуждение: How to find object dependencies in PG 8.4
Hi All,
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.
Venkat
=====-----=====-----===== 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