From: Roberto Mello <rmello@cc.usu.edu>
To: James Orr <james@lrgmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Changing PL/pgSQL triggers
Date: Thu, 21 Jun 2001 11:50:46 -0600
Message-ID: <20010621115046.A15530@cc.usu.edu> (raw)
In-Reply-To: <004d01c0fa77$f64f0580$1600000a@lrg.office>
References: <004d01c0fa77$f64f0580$1600000a@lrg.office>
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.nethttp://www.sdl.usu.edu - Space Dynamics Lab, Developer
*> - | <- Tribble Archery
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rmello@cc.usu.edu, james@lrgmail.com
Subject: Re: Changing PL/pgSQL triggers
In-Reply-To: <20010621115046.A15530@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox