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 ; 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 ; 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 ; Sun, 5 Feb 2006 22:18:29 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 14so1044641nzn for ; 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 To: Padam J Singh 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 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