> That means I have to then go through all my code and make sure I set > the fields value. If I forget to modify one statement, things will > break.
Right, that's why the right answer for what you want to do is to have a trigger. I was just giving you an alternative since you didn't like the trigger answer.
Do you have a superuser account? Pretty sure you gotta have that to create lang. OTOH, plpgsql is a "safe" language once installed, so you should be able to ask your hosting provider to install it. Can't hurt to ask.
For plpgsql I don't believe it actually "installs" anything. The docs make it sound more like it activates it. So as long as you own your database you should be able to
createlang plpgsql -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
