pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alain Lavigne <alavigne@zaq.com>
To: pgsql-sql@postgresql.org
Subject: Re: Changing PL/pgSQL triggers
Date: Thu, 21 Jun 2001 14:10:31 -0400
Message-ID: <9gtd9c$j9j$1@news.tht.net> (raw)
References: <004d01c0fa77$f64f0580$1600000a@lrg.office>

pgAdmin does not let you modify the pl/pgsql triggers.  I use PowerDesigner
7.5 to manage Postgresql physical data models and I edit all pl/pgsql
triggers and functions through that tool.  It's not free but it's the only
one I know that I can Design and Generate Databases ranging from DB2 and
Oracle to Postgresql and MySQL.

Other than that, a simple text editor would do for triggers.


""James Orr"" <james@lrgmail.com> wrote in message
news:004d01c0fa77$f64f0580$1600000a@lrg.office...
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_004A_01C0FA56.5C956540
> Content-Type: text/plain; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 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
crea=
> ting the function and trigger after making a change.  Is there an easier
wa=
> y?
>
> -James
>
> ------=_NextPart_000_004A_01C0FA56.5C956540
> Content-Type: text/html; charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html;
charset=3Diso-8859-1">
> <META content=3D"MSHTML 5.50.4616.200" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>What's the easiest way to modify or view
a=
>  function=20
> written in PL/pgSQL?&nbsp; I've been using pg_dump to get the original
func=
> tion,=20
> then dropping and creating the function and trigger after making a
change.&=
> nbsp;=20
> Is there an easier way?</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
> <DIV><FONT face=3DArial size=3D2>-James</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_004A_01C0FA56.5C956540--
>





view thread (5+ messages)  latest in thread

Message-ID: <9gtd9c$j9j$1@news.tht.net>
Permalink:  ../9gtd9c$j9j$1@news.tht.net/
Also on:    postgresql.org/message-id/9gtd9c$j9j$1@news.tht.net

 · 

reply

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: alavigne@zaq.com
  Subject: Re: Changing PL/pgSQL triggers
  In-Reply-To: <9gtd9c$j9j$1@news.tht.net>

* 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