| From: | "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | Rule or Function and Trigger? | 
| Date: | 2009-04-03 14:29:40 | 
| Message-ID: | 38275.216.185.71.24.1238768980.squirrel@webmail.harte-lyne.ca | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
I am beginning to migrate some functionality from an application
prototype into the DBMS.  One of these elements is time stamping row
insertions and updates.
I have been reading about rules, functions and triggers in regards
to this issue.  So, of course, now I have myself completely
befuddled.  From what I can determine from the documentation, it
makes little difference to the DBMS whether I set a rule on insert
and one on update for each table or define a function and set a
trigger for insert or update on each table.
If this is indeed the case then which way is the preferred method? 
If one looks at things from a code maintenance standpoint it appears
the the function and trigger approach is preferable.  Is it?
Opinions?
-- 
***          E-Mail is NOT a SECURE channel          ***
James B. Byrne                mailto:ByrneJB(at)Harte-Lyne(dot)ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-04-03 14:32:43 | Re: high load on server | 
| Previous Message | Gerd König | 2009-04-03 12:31:26 | high load on server |