Received: from lbdsun.epfl.ch (root@lbdsun.epfl.ch [128.178.77.9]) by hub.org (8.8.8/8.8.8) with ESMTP id SAA25338 for ; Fri, 16 Oct 1998 18:29:44 -0400 (EDT) (envelope-from prochat@lbdsun.epfl.ch) Received: from lbdsun.epfl.ch (tucana.srg-ssr.ch [146.159.4.9]) by lbdsun.epfl.ch (8.8.X/EPFL-8.1a) with ESMTP id AAA22227; Sat, 17 Oct 1998 00:29:39 +0200 (MET DST) Sender: root@lbdsun.epfl.ch Message-ID: <3627CAE2.BB7E1F9D@lbdsun.epfl.ch> Date: Sat, 17 Oct 1998 00:38:26 +0200 From: "Philippe Rochat (RSR: 318 17 93)" Reply-To: prochat@lbdsun.epfl.ch Organization: SIRANAU X-Mailer: Mozilla 4.05 [en] (X11; I; SunOS 5.5.1 sun4m) MIME-Version: 1.0 To: pierre@desertmoon.com, pgsql-sql@postgresql.org Subject: Re: Triggers and SQL functions References: <19981016211726.2888.qmail@desertmoon.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit pierre@desertmoon.com wrote: > > > > > I have exactly the same problem as you mentioned in a mail > > sent to postgres mailing lists about creating trigger using > > sql function ... > > > > Did you get the solution to you problem ? > > > > Ph.R. > > > > > > I actually found the solution in the docs. The solution is to understand > the difference between triggers and rules. Triggers are used primarily > to call C/C++ library functions that you can create and add onto the > postgresql system. > > Rules on the other-hand act just like 'triggers' but only call/usr > sql to perform their functions. > > So the solution: Use rules to create trigger-like actions that run > stored sql procedures. There is a man page on 'create rule' that you > can use to get more info. > > -=pierre I found out the following trick ... but I m not sure it s clean ! -- Makes all user at least belonging to Void ... just in case CREATE FUNCTION adduservoid () returns boolean as 'insert into user_realm select id as uid,1 as rlid,false as adminuser from user where not exists ( select uid from user_realm where user.id=user_realm.uid ); select true as ignore_this;' language 'sql'; CREATE RULE autoadduservoid as on insert to user do select adduservoid(); Ph.R. -- _____________________________________________________________________ Philippe Rochat, EPFL DI-LBD Database Laboratory CH-1015 LAUSANNE Swiss Federal Institute of Technology (EPFL) tel:++41 21 693 52 53 Beep-EPFL: 181 4644 fax:++41 21 693 51 95 Private: Grammont, 9 1007 LAUSANNE tel:++41 21 617 03 05 mailto:Philippe.Rochat@epfl.ch, http://lbdwww.epfl.ch/~prochat