On 6/28/2019 8:07 PM, David Rowley wrote:
On Sat, 29 Jun 2019 at 14:54, Igal @ Lucee.org <igal@xxxxxxxxx> 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 updated record is not lower-cased.
You'll need a BEFORE trigger, not an AFTER trigger.
https://www.postgresql.org/docs/current/sql-createtrigger.html
*facepalm*
I was trying to "save" on creating a separate trigger so I added that to
the bottom of an existing one and missed that.
Thanks David!
Igal
