Subject Re: access rights error when updating on a view with triggers
Author Doru Ilasi
> Is it correct to use: "update test set f2 = new.f1;" ?
As I know , yes is correct.

New.xx and old.xx are "at the record update moment" values, so if you
issue the update command putting new.f2 has no sense within the update
> Will "update test set new.f2 = new.f1;" work ?

Instead of this you may simply put a line
new.f2 = new.f1;
(of course you are WITHIN the code of before/after trigger)
> --
> Aage J.