Received: from serv1.ilse.nl (serv1.ilse.nl [212.189.131.11]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2Q8Xlw64850 for ; Mon, 26 Mar 2001 03:33:49 -0500 (EST) (envelope-from mathijs@serv0.ilse.nl) Received: from serv0.ilse.nl (intra.ilse.nl [10.1.8.249]) by serv1.ilse.nl (8.11.0/8.10.2) with ESMTP id f2Q8XiX35412 for ; Mon, 26 Mar 2001 10:33:44 +0200 (MEST) Received: (from mathijs@localhost) by serv0.ilse.nl (8.11.1/8.11.1) id f2Q8XcP83164 for pgsql-sql@postgresql.org; Mon, 26 Mar 2001 10:33:38 +0200 (CEST) (envelope-from mathijs) Date: Mon, 26 Mar 2001 10:33:38 +0200 From: Mathijs Brands To: pgsql-sql@postgresql.org Subject: Calling Java from psql (was Re: requesting help) Message-ID: <20010326103338.D77438@ilse.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i X-Unexpected-Header: The Spanish Inquisition X-Archive-Number: 200103/514 X-Sequence-Number: 2185 On Mon, Mar 26, 2001 at 09:53:52AM +0200, Poul L. Christiansen allegedly wrote: > Log into PostgreSQL using psql and run the help command: > "\h create trigger". > > See also: > http://www.postgresql.org/users-lounge/docs/6.5/postgres/sql-createtrigger.htm > > HTH, > Poul L. Christiansen > > On Sun, 25 Mar 2001, [iso-8859-1] Mohamed ebrahim wrote: > > > Hi > > I am an user of postgresql. I want to do some > > manipulation on table and i want to do some java stuff > > after inserting a row into table(i.e like sending > > email). I want to fire the trigger to do this after > > the insertion took place. I know how to insert into > > the table but i want to know that it is possible to > > java stuff after inserting rows each time. Please help > > me in this stuff. I will be thankful to you. > > > > Thank you > > Ebrahim Has anybody ever tried calling Java code from a pgsql trigger written in C? Shouldn't this be possible using JNI? I'm not exactly a Java expert myself, but this is the way PHP allows you to call Java code from your PHP scripts. Mathijs -- It's not that perl programmers are idiots, it's that the language rewards idiotic behavior in a way that no other language or tool has ever done. Erik Naggum