Received: from megamail.dsl.net (megamail.dsl.net [209.87.64.97]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5LHQGa79797 for ; Thu, 21 Jun 2001 13:26:16 -0400 (EDT) (envelope-from james@lrgmail.com) Received: from jameslt (64-51-205-180.client.dsl.net [64.51.205.180]) by megamail.dsl.net (8.9.3/8.9.3) with SMTP id NAA04395 for ; Thu, 21 Jun 2001 13:26:14 -0400 Message-ID: <004d01c0fa77$f64f0580$1600000a@lrg.office> From: "James Orr" To: Subject: Changing PL/pgSQL triggers Date: Thu, 21 Jun 2001 13:30:39 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_004A_01C0FA56.5C956540" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200106/334 X-Sequence-Number: 3621 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--