| From: | "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com> |
|---|---|
| To: | "Fontenot, Paul" <Paul(dot)Fontenot(at)bannerhealth(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Functions and triggers |
| Date: | 2003-05-14 07:38:32 |
| Message-ID: | Pine.LNX.4.44.0305141303320.923-100000@Bhuvan.bksys.co.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
> And this is an example of the message field data:
>
> %PIX-3-106011: Deny inbound (No xlate) udp src inside:10.10.1.160/1035
> dst inside:10.29.0.45/161
>
> How would I create and use a function/trigger to key on the PIX error
> message code (%PIX-3-106011)?
You can write a triggered procedure on insert and check the error message
code within that procedure. Check the documentation on howto use triggered
procedure.
Moreover, you can use pgmail to email the details directly from the
triggered procedure. For details of pgmail, please refer
http://pgmail.sourceforge.net .
regards,
bhuvaneswaran
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bogdan Chytrek | 2003-05-14 09:46:08 | Copy command (bug??) |
| Previous Message | Yovko Ilchev Yovkov | 2003-05-14 04:41:47 | Insert on create table |