I think your question is a bit off-topic on this mailinglist. You should
probably post it to pgsql-general.

Anyway, perhaps you'd be interested in looking at


Thomas Hallgren

----- Original Message ----- 
From: "venky" <[EMAIL PROTECTED]>
Newsgroups: comp.databases.postgresql.patches
Sent: Tuesday, January 20, 2004 14:44
Subject: Calling a java program thru a trigger or a function in postgresql

> Here's a high-level overview of what I want to do:
> 1.  A record in a postgresql database is changed.
> 2.  If the change causes the data record to meet certain conditions based
>     Boolean logic, a database trigger will invoke a Java UDF.
> 3.  This Java UDF uses the JavaMail API to send an e-mail to a specified
>     recipient.
> The javamailing program is written separately and is running fine.
> Can any one give me the following details :
> 1.  Where to place the java or class file for access.
> 2.  plz give me the exact create function statements.
> 3.  plz give me the exact create trigger statments.
>              O R
> Plz give me the code to satisfy my requirement.
> Thanks in advance for ur help
> venky

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to