Re: [SQL] Changing PL/pgSQL triggers

2001-06-22 Thread Kristoff Bonne
Greetings, On Thu, 21 Jun 2001, Josh Berkus wrote: >> 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 creating the function and trigger after making a change. >> Is there an easier way? > Well

Re: [SQL] Changing PL/pgSQL triggers

2001-06-21 Thread Roberto Mello
On Thu, Jun 21, 2001 at 01:30:39PM -0400, James Orr wrote: > 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 creating the function >and trigger after making a change. Is there an easier w

[SQL] Changing PL/pgSQL triggers

2001-06-21 Thread James Orr
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 creating the function and trigger after making a change.  Is there an easier way?   -James