Modifying triggers in database in use...

I've sent this once before but it didn't seem to get through
(couldn't find it in the archive)

Hi...

What is the recommended way to make changes to a database in use?

The database is not critical, I can take it down for a day or so but I'd
rather not (or as little as possible anyway). What bothers me is how
hard it is to update functions (primarily triggers) in a nice way.

Using a procedural language is a lot easier but I find it a real pain to
edit functioins created in this way since they're only stored in the
database. You have to retrieve them, edit them and then update them.

Is there a nice way to keep the source elsewhere and reload it in some
simple way? I tried editing database dumps but that feels really bad.

Or would You reccomend that I just get a grip and code it all in C?
(I started but my lazy self really doesn't like it when I know it can be
done so much easier in a procedural language :)

/Daniel (not subscribed)

PS pl/perl doesn't seem to work in debian. Any tips?

--
Now take a deep breath, smile and don't take life so seriously... :)