Postgres Pro
Downloads
Home   >   mailing lists

Re: Trigger function does not modify the NEW value - Mailing list pgsql-general

From David Rowley
Subject Re: Trigger function does not modify the NEW value
Date
Msg-id CAKJS1f_k6umFSAyKQd68YRM0-JF=CsAbZ-ALoCQjCp9WKCpcLg@mail.gmail.com
Whole thread Raw
In response to Trigger function does not modify the NEW value  ("Igal @ Lucee.org" <igal@lucee.org>)
Responses Re: Trigger function does not modify the NEW value
List pgsql-general
Tree view 
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

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-general by date:

Previous
From: "Igal @ Lucee.org"
Date:
Subject: Trigger function does not modify the NEW value
Next
From: "Igal @ Lucee.org"
Date:
Subject: Re: Trigger function does not modify the NEW value