Postgres Pro
Downloads
Home   >   mailing lists

Thread: Invoking java in a trigger

Invoking java in a trigger

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

Dave.

Re: Invoking java in a trigger

From
Martijn van Oosterhout
Date:
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/
> From each according to his ability. To each according to his ability to litigate.
Attachment

Re: Invoking java in a trigger

From
"Shoaib Mir"
Date:
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

Re: Invoking java in a trigger

From
"jungmin shin"
Date:
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

Re: Invoking java in a trigger

From
Thomas Hallgren
Date:
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