Re: 36.3 Writing Tigger Functions in C

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: Dmitry Igrishin <dmitigr(at)gmail(dot)com>, pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: Re: 36.3 Writing Tigger Functions in C
Date: 2015-08-11 11:32:25
Message-ID: 55C9DD49.8060706@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On 8/11/15 12:47 PM, Dmitry Igrishin wrote:
> tg_trigtuple:
> I'm not sure why "skip the operation" is here:
> "if you don't want to replace the row with a different one (in the
> case of INSERT) or skip the operation"

Returning NULL from a row-level BEFORE trigger skips the operation which
fired the trigger. So for an INSERT, any triggers which would otherwise
fire after the current trigger are not fired, and the row is not
INSERTed into the table.

.m

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Dmitry Igrishin 2015-08-11 11:51:28 Re: 36.3 Writing Tigger Functions in C
Previous Message Dmitry Igrishin 2015-08-11 11:20:32 Re: 36.3 Writing Tigger Functions in C