- Архив списков рассылки pgsql-general

Ugh, would someone be so kind as to explain to me what I have missed in
this setup? I have my table (syslogtb), and when a PIX log entry - in
this case the entry is "%PIX-3-305005 blah_blah_blah" - I've read what I
can and thought that I had it understood HOWEVER... When I load the
function and set the trigger I no longer get any inserts into the
database. I have included the table layout, the function, the trigger,
and an example log entry from the PIX.

###
### Table syslog.syslogtb
###
create table syslogtb (
         facility char(10),
         priority char(10),
         date date,
         time time,
         host varchar(128),
         message  text
);

###
### Function
###
create function SyslogMail() returns opaque as '
DECLARE
        logRec RECORD;
        textMessage text;
BEGIN
        select into logRec date,time,message from syslogtb where message
= NEW.message;
        if logRec.message like ''%PIX-3-305005%'' then
                textMessage := ''The following log entry was recieved
from the PIX:'' || logRec.date, logRec.time, logRec.message;
                perform pgmail(''Syslog <some_email_addy>'',''Paul
<my_email_addy>'',''PIX Event'', textMessage);
        end if;
        return NEW;
END;' language 'plpgsql';

###
### Trigger
###
CREATE TRIGGER trgSyslogMail
        AFTER INSERT ON syslogtb FOR EACH ROW
        EXECUTE PROCEDURE SyslogMail();

###
### Example PIX log entry
###
  facility  |  priority  |    date    |   time   |          host
|                message

------------+------------+------------+----------+----------------------
---+-------------------------------------
 local6     | err        | 2003-05-26 | 13:10:11 |
XXXXXX.XXXXXXXXXXXX.XXX | %PIX-3-305005: No translation group found for
tcp src outside:63.136.222.30/62503 dst inside:xxx.xxx.xx.x/80

HOPEFULLY, I've explained that well enough and thanks for your help in
advance.