From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-sql@postgresql.org
Cc: Rod Taylor <pg@rbt.ca>
Subject: Re: Function Dependency
Date: Mon, 6 Feb 2006 12:29:09 +0100
Message-ID: <20060206112907.GA5199@merkur.hilbert.loc> (raw)
In-Reply-To: <6d8daee30602051818s27078bfhf7e3611bb760d57c@mail.gmail.com>
References: <43E1A5A0.1000401@inventum.cc>
<6d8daee30602051818s27078bfhf7e3611bb760d57c@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Karsten.Hilbert@gmx.net, pg@rbt.ca
Subject: Re: Function Dependency
In-Reply-To: <20060206112907.GA5199@merkur.hilbert.loc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox