Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5MCcNa48825 for ; Fri, 22 Jun 2001 08:38:23 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5LIVba11399 for ; Thu, 21 Jun 2001 14:31:37 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f5LI9oU19766 for pgsql-sql@postgresql.org; Thu, 21 Jun 2001 14:09:50 -0400 (EDT) (envelope-from news) From: "Alain Lavigne" X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Changing PL/pgSQL triggers Date: Thu, 21 Jun 2001 14:10:31 -0400 Organization: ZAQ.iTv Lines: 60 Message-ID: <9gtd9c$j9j$1@news.tht.net> References: <004d01c0fa77$f64f0580$1600000a@lrg.office> X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 To: pgsql-sql@postgresql.org X-Archive-Number: 200106/364 X-Sequence-Number: 3651 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"" 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 > > > > > > > > >
Hi,
>
 
>
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?
>
 
>
-James
> > ------=_NextPart_000_004A_01C0FA56.5C956540-- >