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: ntquocvinh(at)ued(dot)vn(dot)
Thank you for attentions.