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" <[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 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings