Email DML Errors and Constraint Violations
Started by Raymondover 22 years ago2 messagesgeneral
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
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 |
+---------------------------------------------------------------+