Received: from mail.retep.org.uk ([216.126.85.184]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2T9CIU36298 for ; Thu, 29 Mar 2001 04:12:21 -0500 (EST) (envelope-from peter@retep.org.uk) Received: from heather.retep.org.uk ([193.113.117.200]) (authenticated) by mail.retep.org.uk (8.11.3/8.11.1) with ESMTP id f2T9BgW36249; Thu, 29 Mar 2001 04:11:48 -0500 (EST) (envelope-from peter@retep.org.uk) Message-Id: <5.0.2.1.0.20010329100409.02122480@mail.retep.org.uk> X-Sender: peter@mail.retep.org.uk X-Mailer: QUALCOMM Windows Eudora Version 5.0.2 Date: Thu, 29 Mar 2001 10:09:02 +0100 To: Mathijs Brands , pgsql-sql@postgresql.org From: Peter Mount Subject: Re: Calling Java from psql (was Re: requesting help) In-Reply-To: <20010326103338.D77438@ilse.nl> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200103/598 X-Sequence-Number: 2268 At 10:33 26/03/01 +0200, Mathijs Brands wrote: >Has anybody ever tried calling Java code from a pgsql trigger written >in C? Shouldn't this be possible using JNI? This was discussed recently. >I'm not exactly a Java expert myself, but this is the way PHP allows >you to call Java code from your PHP scripts. It may be something to look at when things quieten down a bit. I'm rushed of my feet at the moment (busy at work, long hours etc) but once 7.1 is finally out of the door, I may get the chance to start looking at JNI (& my employers don't mind me spending some time working on postgres when I'm not on other projects either which is nice ;-) ) PS: the JDBC list is the best place for java based emails - I rarely read sql ;-) Peter