[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: Trigger function does not modify the NEW value
From: "Igal () Lucee ! org" <igal () lucee ! org>
Date: 2019-06-29 3:13:16
Message-ID: 1476e550-ac2e-949a-5f4d-b29d0ad1203e () lucee ! org
[Download RAW message or body]
On 6/28/2019 8:07 PM, David Rowley wrote:
> On Sat, 29 Jun 2019 at 14:54, Igal @ Lucee.org <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 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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic