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 code that does not modify any values but calls PERFORM
on another function */
raise notice 'lowercasing %', new.email;
new.email = lower(new.email);
raise notice ' to %', new.email;
return new;
$$
I can see in the output the notices with the expected values, but the
value in the updated record is not lower-cased.
update some_table
set email = 'i...@lucee.org'
where id = 1;
> 00000: lowercasing i...@lucee.org
> 00000: to i...@lucee.org
select email
from some_table
where id = 1;
> email |
> --------------|
> i...@lucee.org|
Any ideas?
Thanks,
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
