From padam.singh@inventum.cc Thu Feb  2 06:31:23 2006
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 F21C19DC807
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Feb 2006 02:31:23 -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 39576-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu,  2 Feb 2006 02:31:23 -0400 (AST)
X-Greylist: delayed 00:06:40.053121 by SQLgrey-
Received: from sitara.inventum.cc (unknown [69.20.4.27])
	by postgresql.org (Postfix) with SMTP id 16C7B9DC81E
	for <pgsql-sql@postgresql.org>; Thu,  2 Feb 2006 02:31:19 -0400 (AST)
Received: (qmail 17585 invoked from network); 2 Feb 2006 06:41:54 -0000
Received: from unknown (HELO ?192.168.1.2?) (127.0.0.1)
	by 127.0.0.1 with SMTP; 2 Feb 2006 06:41:54 -0000
Message-ID: <43E1A5A0.1000401@inventum.cc>
Date: Thu, 02 Feb 2006 11:54:32 +0530
From: Padam J Singh <padam.singh@inventum.cc>
Organization: Inventum  Technologies Pvt Ltd
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20050923)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Function Dependency
Content-Type: multipart/mixed; boundary="------------030008020104050005080209"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001]
X-Spam-Score: 0.001
X-Spam-Level: 
X-Archive-Number: 200602/16
X-Sequence-Number: 24026

This is a multi-part message in MIME format.
--------------030008020104050005080209
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000066">
<font size="-1"><font face="Helvetica, Arial, sans-serif">Hello,<br>
<br>
I am maintaining an application that has over 400 procedures and
functions written in plsql, and around 100 tables.<br>
I want to generate a function dependency chart to depict the following:<br>
<br>
1. Inter function/procedure dependencies<br>
2. function-tables dependencies<br>
3. function-sequences depencies<br>
<br>
Is there a standard method of doing this? <br>
<br>
Thanks in advance,<br>
Padam.<br>
</font></font>
</body>
</html>

--------------030008020104050005080209
Content-Type: text/x-vcard; charset=utf-8;
 name="padam.singh.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="padam.singh.vcf"

begin:vcard
fn:Padam Singh
n:Singh;Padam
org:Inventum Technologies Pvt. Ltd.;Engineering
adr:SDA Commercial Complex;;C-17;New Delhi;Delhi;110016;India
email;internet:padam.singh@inventum.cc
title:Sr. Solutions Architect
tel;work:+91-11-55650222
tel;fax:+91-11-26518800
tel;cell:+91-9810146640
x-mozilla-html:TRUE
url:http://www.inventum.cc
version:2.1
end:vcard


--------------030008020104050005080209--



From ajwasson@gmail.com Mon Feb  6 02:18:32 2006
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 320079DCAA6
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun,  5 Feb 2006 22:18:32 -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 72344-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun,  5 Feb 2006 22:18:35 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.201])
	by postgresql.org (Postfix) with ESMTP id DEB429DCABE
	for <pgsql-sql@postgresql.org>; Sun,  5 Feb 2006 22:18:29 -0400 (AST)
Received: by zproxy.gmail.com with SMTP id 14so1044641nzn
	for <pgsql-sql@postgresql.org>; Sun, 05 Feb 2006 18:18:34 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=ixWnnH+pUZIzAlkQOL5jXb5LppFuBD4VgZefXTH8PwrB8wHciYO4kCg2t4q2FKIupDbqNyUp+o7dnGf1eD0aB+h7eN/28O2e9qr/z/wKeHK25SDBDHoZzmZ5fLRvUwGYvaiVIAUncW+ZmzBf/3gAhSRL4WiGpz2bWT1nqBk3BiI=
Received: by 10.36.100.20 with SMTP id x20mr3770256nzb;
	Sun, 05 Feb 2006 18:18:33 -0800 (PST)
Received: by 10.37.14.48 with HTTP; Sun, 5 Feb 2006 18:18:33 -0800 (PST)
Message-ID: <6d8daee30602051818s27078bfhf7e3611bb760d57c@mail.gmail.com>
Date: Sun, 5 Feb 2006 19:18:33 -0700
From: Tony Wasson <ajwasson@gmail.com>
To: Padam J Singh <padam.singh@inventum.cc>
Subject: Re: Function Dependency
Cc: pgsql-sql@postgresql.org
In-Reply-To: <43E1A5A0.1000401@inventum.cc>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <43E1A5A0.1000401@inventum.cc>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.154 required=5 tests=[AWL=0.154]
X-Spam-Score: 0.154
X-Spam-Level: 
X-Archive-Number: 200602/42
X-Sequence-Number: 24052

On 2/1/06, Padam J Singh <padam.singh@inventum.cc> wrote:
>  Hello,
>
>  I am maintaining an application that has over 400 procedures and functio=
ns
> 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



From Karsten.Hilbert@gmx.net Mon Feb  6 11:29:13 2006
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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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 <karsten.hilbert@gmx.net>)
	id 1F64YP-0001bp-8k; Mon, 06 Feb 2006 12:29:09 +0100
Date: Mon, 6 Feb 2006 12:29:09 +0100
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-sql@postgresql.org
Cc: Rod Taylor <pg@rbt.ca>
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