Dear sir/madam. We build a program that can automatically generate triggers in C-language for synchronous incremental matview update. It supports queries with limitations: - inner join - group by with sum, count, avg, min, max - the join has to be of the form: t1 1-n t2 1-n t3 1-n t4....
The binary and source can be find at http://it.ued.vn/myprojects/pgTriggerGen/. It is the first version. We now are build another version with some improvements. Anyone can use it if they find it useful. All comments, recommendations, improvements are welcome. Corresponding address: ntquocv...@ued.vn. Thank you for attentions.