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> </DIV>
> <DIV><FONT face=3DArial size=3D2>What's the easiest way to modify or view
a=
> function=20
> written in PL/pgSQL? 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> </DIV>
> <DIV><FONT face=3DArial size=3D2>-James</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_004A_01C0FA56.5C956540--
>