Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5LHowa91348 for ; Thu, 21 Jun 2001 13:50:58 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id f5LHokga015544; Thu, 21 Jun 2001 11:50:46 -0600 Date: Thu, 21 Jun 2001 11:50:46 -0600 From: Roberto Mello To: James Orr Cc: pgsql-sql@postgresql.org Subject: Re: Changing PL/pgSQL triggers Message-ID: <20010621115046.A15530@cc.usu.edu> References: <004d01c0fa77$f64f0580$1600000a@lrg.office> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <004d01c0fa77$f64f0580$1600000a@lrg.office> User-Agent: Mutt/1.3.18i X-Archive-Number: 200106/336 X-Sequence-Number: 3623 On Thu, Jun 21, 2001 at 01:30:39PM -0400, James Orr wrote: > Hi, > > What's the easiest way to modify or view a function written in PL/pgSQL? I've been using pg_dump to get the original function, then dropping and creating the function and trigger after making a change. Is there an easier way? pgAcess should make it easier. It lets you look at the definition and lets you modify/drop/recreate it. If you're on windows, you might want to look a pgAdmin (available at greatbridge.org). -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer *> - | <- Tribble Archery