[Info-ingres] Update rule also triggered when inserting rows?

nksvg1 at gmail.com nksvg1 at gmail.com
Thu Feb 22 10:34:29 UTC 2018


the architecture as it is :

there are two procedures, 'insert_bi_date_asqenh' and 'update_bi_date_asqenh'.
When an insert in table 'bi_date_asqenh' is taking place the 'insert_bi_date_asqenh' rule is fired which calls the 'insert_bi_date_asqenh' procedure which raises a DBEVENT.Similarly, upon an 'update' happening.

A Perl daemon (on Linux) is listening for those dbevents, captures them,extracts the bundled parameters/data, and then calls another Perl script propagating this data.This script in turn builds an XML file after the data and forwards the file to a REST web service.

There's more procedures and events going on which work just fine and I can attest that Ingres' dbevents functionality is pretty stable.The only one giving me heat is the 'update_bi_date_asqenh' rule/procedure which it seems like is being fired erratically and out of sync.

With that in mind,where should I call 'set printrules' from ?



More information about the Info-ingres mailing list