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
----- Original Message -----
From: "venky" <venkycraj(at)yahoo(dot)com>
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
> 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
In response to
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2004-02-12 15:40:23|
|Subject: Re: Some new SPI functions |
|Previous:||From: Thomas Hallgren||Date: 2004-02-12 11:53:39|
|Subject: Some new SPI functions|