Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] trigger on delete/field update - Mailing list pgsql-novice

From David G. Johnston
Subject Re: [NOVICE] trigger on delete/field update
Date
Msg-id CAKFQuwZwkYGWQ5paACtgJKMrK+t7y4kCvD_c6VzcJj7QDMZGaQ@mail.gmail.com
Whole thread Raw
In response to [NOVICE] trigger on delete/field update  (Ruslan R. Laishev <zator@yandex.ru>)
List pgsql-novice
Tree view
On Mon, Oct 16, 2017 at 7:27 AM, Ruslan R. Laishev <zator@yandex.ru> wrote:
So, what I'm need to check ?

​I assume you are using a BEFORE trigger on the table...​

​The docs imply what you want to do is not possible using triggers.

https://www.postgresql.org/docs/10/static/plpgsql-trigger.html#plpgsql-dml-trigger

"​Row-level triggers fired BEFORE can return null to signal the trigger manager to skip the rest of the operation for this row (i.e., subsequent triggers are not fired, and the INSERT/UPDATE/DELETE does not occur for this row)."

It might be possible to accomplish your goal with an INSTEAD OF trigger on a View over the table...I have never tried this.

https://www.postgresql.org/docs/10/static/sql-createtrigger.html

David J.

pgsql-novice by date:

Previous
From: Adarsh Jaiswal
Date:
Subject: Re: [NOVICE] The server does not listen
Next
From: Moreno Andreo
Date:
Subject: Re: [NOVICE] The server does not listen