Re: Changing PL/pgSQL triggers

James,

> 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, if you're on Win32 or on Linux, you can install PGAccess (link
from postgresql.org).  PGAccess has an OK function editor, although it
doesn't support cut-and-paste on Xwindows and I've found a few bugs with
large and complex functions.

Me, I write lots and lots of PL/pgSQL functions.  I've found the easiest
way to be (I'm on SuSE 7.0/KDE2.1):

1. Create text file, and write and edit function in KEdit.

2. Save text file.

3. Load function using \i in PSQL.

4. Test function.  FInd bug(s).

5. Re-edit function using Kedit.  Add DROP FUNCTION command at
beginning.

6. Re-load function using \i in PSQL.

7. Repeat from 4 until function is debugged.

It sounds like a lot of steps, but really it goes quickly.  Plus it
allows you to save lots of intermediate versions of functions.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco