Email DML Errors and Constraint Violations

Started by Raymondover 22 years ago2 messagesgeneral
Jump to latest
#1Raymond
support@bigriverinfotech.com

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

#2Ron Johnson
ron.l.johnson@cox.net
In reply to: Raymond (#1)
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                                               |
+---------------------------------------------------------------+