Re: Calling a java program thru a trigger or a function in postgresql

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
http://gborg.postgresql.org/project/pljava.

Regards,

Thomas Hallgren

----- Original Message -----
From: "venky" <venkycraj(at)yahoo(dot)com>
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
on
> 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