Fontenot, Paul wrote:
> I'm going nuts, when I have this table/function/trigger combo my table
> never updates - works great as soon as I drop the trigger. Can someone
> not so green in PostgreSQL take a gander and tell me what I've done
> wrong?
[...snip...]
> textMessage := ''The PIX has generated the following: ''
> logRec.message '''';
The only thing I can see wrong is the above line. You probably want
something like:
textMessage := ''The PIX has generated the following: '' || logRec.message;
or maybe:
textMessage := ''The PIX has generated the following: '''''' ||
logRec.message || '''''''';
HTH,
Joe