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
------------------------------------------------------------------