From: Tony Wasson <ajwasson@gmail.com>
To: Padam J Singh <padam.singh@inventum.cc>
Cc: pgsql-sql@postgresql.org
Subject: Re: Function Dependency
Date: Sun, 5 Feb 2006 19:18:33 -0700
Message-ID: <6d8daee30602051818s27078bfhf7e3611bb760d57c@mail.gmail.com> (raw)
In-Reply-To: <43E1A5A0.1000401@inventum.cc>
References: <43E1A5A0.1000401@inventum.cc>
On 2/1/06, Padam J Singh <padam.singh@inventum.cc> wrote:
> Hello,
>
> 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
>
> Is there a standard method of doing this?
>
> Thanks in advance,
> Padam.
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 Wasson
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: ajwasson@gmail.com, padam.singh@inventum.cc
Subject: Re: Function Dependency
In-Reply-To: <6d8daee30602051818s27078bfhf7e3611bb760d57c@mail.gmail.com>
* 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