Re: Trigger function does not modify the NEW value

2019-06-28 Thread Igal @ Lucee.org
On 6/28/2019 8:07 PM, David Rowley wrote: On Sat, 29 Jun 2019 at 14:54, Igal @ Lucee.org wrote: create trigger tr_on_table_modified after insert or delete or update on some_table for each row execute procedure on_table_modified(); I can see in the output the notices with the expec

Re: Trigger function does not modify the NEW value

2019-06-28 Thread David Rowley
On Sat, 29 Jun 2019 at 14:54, Igal @ Lucee.org wrote: > create trigger tr_on_table_modified after insert or delete or update > on some_table for each row execute procedure on_table_modified(); > I can see in the output the notices with the expected values, but the value > in the upda

Trigger function does not modify the NEW value

2019-06-28 Thread Igal @ Lucee.org
I have a trigger that is created like so:     create trigger tr_on_table_modified after insert or delete or update         on some_table for each row execute procedure on_table_modified();     CREATE OR REPLACE FUNCTION on_table_modified() RETURNS trigger LANGUAGE plpgsql $$         /* some cod