[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