Received: from bleys.tpgi.com.au (bleys.tpgi.com.au [203.12.160.38]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2L7Vwt30649 for ; Wed, 21 Mar 2001 02:31:58 -0500 (EST) (envelope-from quals@bigfoot.com) Received: (from smtpd@localhost) by bleys.tpgi.com.au (8.11.2/8.11.2) id f2L7Uh403127 for ; Wed, 21 Mar 2001 18:30:43 +1100 Received: from bri-56k-042.tpgi.com.au(203.12.164.42), claiming to be "hnjack" via SMTP by bleys.tpgi.com.au, id smtpdNH6a5p; Wed Mar 21 18:30:42 2001 Message-ID: <000d01c0b1d8$5b63e6e0$2400a8c0@hnjack> From: "datactrl" To: Subject: how do I find which ... Date: Wed, 21 Mar 2001 17:27:15 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200103/411 X-Sequence-Number: 2079 I write some functions inPL/pgSQL. If I drop a function B , which is called by function A, and create function B again, then function A won't work unless I drop function A and re-create again. How about if there are lots functions call to function B, is there any way to search system table to find out those functions call to A? JACK