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

nksvg1 at gmail.com nksvg1 at gmail.com
Thu Feb 22 08:42:14 UTC 2018


I've got those two rules:

create rule insert_bi_date_asqenh after insert on bi_date_asqenh
execute procedure insert_bi_date_asqenh_proc  (
c_grnoe   = new.c_grnoe,
d_episkep = new.d_episkep,
iatreio   = new.iatreio,
end_yper  = new.end_yper
)


create rule update_bi_date_asqenh after update (type) on bi_date_asqenh
execute procedure update_bi_date_asqenh  (
c_grnoe   = new.c_grnoe,
d_episkep = new.d_episkep,
iatreio   = new.iatreio,
end_yper  = new.end_yper,
error= new.error,
type=new.type
)

I'm trying to debug the update rule firing when it shouldn't, or I think it shouldn't and I got the impression that the update rule is fired automatically after the insert rule is fired, i.e after a row being insert

Is my assumption correct,or should I look elsewhere?



More information about the Info-ingres mailing list