Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f27I5Nx25717; Wed, 7 Mar 2001 13:05:23 -0500 (EST) (envelope-from jliang@tidal.ipinc.com) Received: from localhost (jliang@localhost) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id KAA57463; Wed, 7 Mar 2001 10:05:13 -0800 (PST) (envelope-from jliang@tidal.ipinc.com) Date: Wed, 7 Mar 2001 10:05:13 -0800 (PST) From: Jie Liang To: Tom Lane cc: "'PostgreSQL Admin News'" , pgsql-sql@postgresql.org Subject: how to reload a function In-Reply-To: <477.982962443@sss.pgh.pa.us> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200103/55 X-Sequence-Number: 901 I have 2 plpgsql defined functions, say: create function A(....) returns ... as' ..... 'language 'plpgsql'; create function B(....) returns ... as ' declare .... begin select A(..) into myvar from .... .... end; 'language 'plpgsql'; If I modify function A (drop && re_create), then I have to re_create function B though no change to function B. Is there any way (sql stmt) let me re_load function B's defination without using drop and create?? Thanks. Jie LIANG St. Bernard Software 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.stbernard.com www.ipinc.com