Posted by: Anonymous Coward
on November 12, 2006 10:45 AM
Ok, there are two ways to do this, both of which take advantage of PostgreSQL triggers.
But that's the wrong approach. Integration based on PostgreSQL triggers means I need intimate knowledge of the database schema. If the database schema ever changes, my triggers might break or be inappropriate.
I want triggers like:
$X.YY has been received from customer Q and posted as Cash Received.
Invoice nnnn has been fully paid.
Invoice mmmm is now 30 days past due (this would probably need to be checked from cron)
These high-level actions need an API, something you alluded to.
Learn about Linux
Download Linux
Get Linux help
Re:More details on integration
Posted by: Anonymous Coward on November 12, 2006 10:45 AMOk, there are two ways to do this, both of which take advantage of PostgreSQL triggers.
But that's the wrong approach. Integration based on PostgreSQL triggers means I need intimate knowledge of the database schema. If the database schema ever changes, my triggers might break or be inappropriate.
I want triggers like:
These high-level actions need an API, something you alluded to.
#