Re: Trigger/Rules Order of operations

On 16/12/2008 16:26, Ketema wrote:
> automatically after certain input.  In analyzing the task I saw two
> main paths.  Use the trigger and rule system that Pg provides or
> construct external methods to control the logic and issue "simple"
> commands to insert data when appropriate.  I chose to use the trigger

You could encapsulate your business rules in functions (pl/pgsql or
whatever) within the database....easier to understand what's going on
(speaking as one who is completely ignorant about the rule system) and
you get full ACIDity.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------