public inbox for [email protected]  

help / color / mirror / Atom feed

From: Marko Tiikkaja <[email protected]>
To: Dmitry Igrishin <[email protected]>
To: pgsql-docs <[email protected]>
Subject: Re: 36.3 Writing Tigger Functions in C
Date: Tue, 11 Aug 2015 13:32:25 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAAfz9KPBchVLG=MxOcD7wWiRjBQJ2CDckqC3RRYrkehy=9wedw@mail.gmail.com>
References: <CAAfz9KPBchVLG=MxOcD7wWiRjBQJ2CDckqC3RRYrkehy=9wedw@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-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


-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: 36.3 Writing Tigger Functions in C
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox