Rule or Function and Trigger?

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-general by date

  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