Thread: Email DML Errors and Constraint Violations

Email DML Errors and Constraint Violations

From
Raymond
Date:
Utilizing Postgres 7.3.3 and RH80.

Any way to email DML errors and constraint violations from Postgres?

Need something event driven; polling logs is not a good solution.

Would be very effective to monitor 3rd party client incremental development
and testing.

Raymond

Re: Email DML Errors and Constraint Violations

From
Ron Johnson
Date:
On Sun, 2003-08-10 at 19:43, Raymond wrote:
> Utilizing Postgres 7.3.3 and RH80.
>
> Any way to email DML errors and constraint violations from Postgres?
>
> Need something event driven; polling logs is not a good solution.
>
> Would be very effective to monitor 3rd party client incremental development
> and testing.

Sounds like a job for the postmaster.  Maybe messages going to the
log file could be tee'd off somehow and piped to a mail script?

--
+---------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net           |
| Jefferson, LA  USA                                            |
|                                                               |
| "Man, I'm pretty.  Hoo Hah!"                                  |
|    Johnny Bravo                                               |
+---------------------------------------------------------------+