Re: Email DML Errors and Constraint Violations

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Email DML Errors and Constraint Violations
Date: 2003-08-11 02:13:06
Message-ID: 1060567985.21664.23.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA |
| |
| "Man, I'm pretty. Hoo Hah!" |
| Johnny Bravo |
+---------------------------------------------------------------+

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Schmidt 2003-08-11 02:42:11 Re: OT: Address Fields
Previous Message Dustin Sallings 2003-08-11 01:31:13 Commercial support?