Invoking java in a trigger

Started by Dave Pottsover 19 years ago5 messagesgeneral
Jump to latest
#1Dave Potts
dave.potts@pinan.co.uk

Is it possible to invoke a computer language other than postgres sql as
the result of a trigger firing, eg something like Java.

Dave.

#2Shoaib Mir
shoaibmir@gmail.com
In reply to: Dave Potts (#1)
Re: Invoking java in a trigger

PL/Java might help you here....

Thank you,
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

Show quoted text

On 11/3/06, David Potts <dave.potts@pinan.co.uk> wrote:

Is it possible to invoke a computer language other than postgres sql as
the result of a trigger firing, eg something like Java.

Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

#3Martijn van Oosterhout
kleptog@svana.org
In reply to: Dave Potts (#1)
Re: Invoking java in a trigger

On Fri, Nov 03, 2006 at 03:22:40PM -0000, David Potts wrote:

Is it possible to invoke a computer language other than postgres sql as
the result of a trigger firing, eg something like Java.

Sure, many languages are supported, C, perl, tcl, python and yes, even Java.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Show quoted text

From each according to his ability. To each according to his ability to litigate.

#4jungmin shin
jungmin.shin@gmail.com
In reply to: Shoaib Mir (#2)
Re: Invoking java in a trigger

Regarding this question,
I'm wondering that the ways of executing stored procedure, triggers and
user-defined function are all the same in view of a query planning.

Thanks,
jungmin

On 11/3/06, Shoaib Mir <shoaibmir@gmail.com> wrote:

PL/Java might help you here....

Thank you,
-------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 11/3/06, David Potts <dave.potts@pinan.co.uk> wrote:

Is it possible to invoke a computer language other than postgres sql as
the result of a trigger firing, eg something like Java.

Dave.

---------------------------(end of broadcast)---------------------------

TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
Jungmin Shin

#5Thomas Hallgren
thhal@mailblocks.com
In reply to: Dave Potts (#1)
Re: Invoking java in a trigger

David Potts wrote:

Is it possible to invoke a computer language other than postgres sql as
the result of a trigger firing, eg something like Java.

Dave.

http://wiki.tada.se/wiki/display/pljava/Home

Regards,
Thomas Hallgren