From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: General trigger function |
Date: | 2002-06-13 08:50:45 |
Message-ID: | 200206130950.45528.dev@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Wednesday 12 Jun 2002 9:32 pm, Jan Wieck wrote:
> 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.
Or look in the cookbook linked from techdocs.postgresql.org - there's an
example in there of a "trigger maker" which builds last-changed tracking
triggers and functions. You do something like:
select lastchg_addto('TABLE-NAME','TIMESTAMP-COLUMN-NAME')
And it creates the relevant function and trigger code then EXECUTEs it.
Shouldn't take much to alter it for your purposes
- Richard Huxton
From | Date | Subject | |
---|---|---|---|
Next Message | Svenn Helge Grindhaug | 2002-06-13 10:11:37 | Rule problem |
Previous Message | Vernon Wu | 2002-06-13 07:50:07 | Re: Please help me out on this insert error |