Re: Changing PL/pgSQL triggers

From: "Alain Lavigne" <alavigne(at)zaq(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Changing PL/pgSQL triggers
Date: 2001-06-21 18:10:31
Message-ID: 9gtd9c$j9j$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)lrgmail(dot)com> wrote in message
news:004d01c0fa77$f64f0580$1600000a(at)lrg(dot)office(dot)(dot)(dot)
> 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--
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Joseph Shraibman 2001-06-21 19:04:21 Re: select by streak
Previous Message Tom Lane 2001-06-21 17:54:02 Re: Correct syntex for implicit curor in for loops