Re: Email DML Errors and Constraint Violations - Mailing list pgsql-general

From Ron Johnson
Subject Re: Email DML Errors and Constraint Violations
Date
Msg-id 1060567985.21664.23.camel@haggis
Whole thread Raw
In response to Email DML Errors and Constraint Violations  (Raymond <support@bigriverinfotech.com>)
List pgsql-general
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                                               |
+---------------------------------------------------------------+



pgsql-general by date:

Previous
From: Eduard Bondarenko
Date:
Subject: Authentication problem
Next
From: Paul Schmidt
Date:
Subject: Re: OT: Address Fields