X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 8CD7F9DC994 for ; Mon, 6 Feb 2006 07:29:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36660-08 for ; Mon, 6 Feb 2006 07:29:14 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.net [213.165.64.21]) by postgresql.org (Postfix) with SMTP id C70209DC811 for ; Mon, 6 Feb 2006 07:29:09 -0400 (AST) Received: (qmail invoked by alias); 06 Feb 2006 11:29:11 -0000 Received: from L70d2.l.strato-dslnet.de (EHLO merkur.hilbert.loc) [89.48.112.210] by mail.gmx.net (mp011) with SMTP; 06 Feb 2006 12:29:11 +0100 X-Authenticated: #1433807 Received: from ncq by merkur.hilbert.loc with local (Exim 4.60) (envelope-from ) id 1F64YP-0001bp-8k; Mon, 06 Feb 2006 12:29:09 +0100 Date: Mon, 6 Feb 2006 12:29:09 +0100 From: Karsten Hilbert To: pgsql-sql@postgresql.org Cc: Rod Taylor Subject: Re: Function Dependency Message-ID: <20060206112907.GA5199@merkur.hilbert.loc> References: <43E1A5A0.1000401@inventum.cc> <6d8daee30602051818s27078bfhf7e3611bb760d57c@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6d8daee30602051818s27078bfhf7e3611bb760d57c@mail.gmail.com> User-Agent: Mutt/1.5.11 X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.433 required=5 tests=[AWL=0.157, MAILTO_TO_SPAM_ADDR=0.276] X-Spam-Score: 0.433 X-Spam-Level: X-Archive-Number: 200602/47 X-Sequence-Number: 24057 On Sun, Feb 05, 2006 at 07:18:33PM -0700, Tony Wasson wrote: > > I am maintaining an application that has over 400 procedures and functions > > written in plsql, and around 100 tables. > > I want to generate a function dependency chart to depict the following: > > > > 1. Inter function/procedure dependencies > > 2. function-tables dependencies > > 3. function-sequences depencies ... > I too would be interested in a standardized tool to do this. I had a > similar situation and I ended up writing a perl script to parse my SQL > and make a graphviz dot file. I then used graphviz to make a function > dependency chart. I can't promise it would catch every single case, > but I can provide you with the code if you wish to give it a whirl. Tony, what do you think about sending a copy of this code to the pg_autodoc author ? I'm sure they'd be interested to have a look at this. http://www.rbt.ca/autodoc/index.html I have CC'ed this to the author. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346