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@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
