From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | GRIMOIS Eric <eric(dot)grimois(at)cpam-cergypontoise(dot)cnamts(dot)fr> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: General trigger function |
Date: | 2002-06-12 20:32:05 |
Message-ID: | 3D07AFC5.8F5413BF@Yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2002-06-12 23:34:30 | Re: make a unique index for foreign keys? |
Previous Message | Manfred Koizar | 2002-06-12 18:06:11 | Re: Efficient DELETE Strategies |