Re: Changing PL/pgSQL triggers
| От | Alain Lavigne |
|---|---|
| Тема | Re: Changing PL/pgSQL triggers |
| Дата | |
| Msg-id | 9gtd9c$j9j$1@news.tht.net обсуждение исходный текст |
| Ответ на | Changing PL/pgSQL triggers ("James Orr" <james@lrgmail.com>) |
| Список | 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@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-- >
В списке pgsql-sql по дате отправления: