Re: General trigger function - Mailing list pgsql-sql

From Jan Wieck
Subject Re: General trigger function
Date
Msg-id 3D07AFC5.8F5413BF@Yahoo.com
Whole thread Raw
In response to General trigger function  ("GRIMOIS Eric" <eric.grimois@cpam-cergypontoise.cnamts.fr>)
Responses Re: General trigger function  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
GRIMOIS Eric wrote:
> 
> Hi all
> 
> I read in the doc than a same function can be used for several triggers.
> I tried to create a function who updates a field with a timestamp and
> another field with the user name. This function is fired by triggers in
> several tables.
> It only works if updated fields have same names in all tables. I failed to
> create a function where fields names are parameters of the function.
   You could do that with the EXECUTE functionality. But that   causes *every* execution of these statemets not beeing
cacheable, so it'll have an impact on performance. 
 


Jan

> 
> What's the way to do that ?
> Thanks.
> 
> Eric GRIMOIS
> Analyste programmeur
> SEI - CPAM du Val d'Oise
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-sql by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: Efficient DELETE Strategies
Next
From: Josh Berkus
Date:
Subject: Re: make a unique index for foreign keys?