pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Adrian Klaver <adrian.klaver@aklaver.com>
To: avpro avpro <avprowebeden@gmail.com>
To: pgsql-performance@postgresql.org
To: pgsql-general@postgresql.org
Subject: Re: trigger Before or After
Date: Tue, 11 Nov 2014 05:58:49 -0800
Message-ID: <54621619.2040505@aklaver.com> (raw)
In-Reply-To: <CAAQdDnnb9E89=RxZbu6Fdv1eLtM7bQG9CLAsmYWxKZarnzXRQg@mail.gmail.com>
References: <CAAQdDnnb9E89=RxZbu6Fdv1eLtM7bQG9CLAsmYWxKZarnzXRQg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>

On 11/10/2014 10:38 PM, avpro avpro wrote:
> hi,
>
> in the pgsql documentation
> (http://www.postgresql.org/docs/9.1/static/sql-createtrigger.html)
>
> i haven't seen anything referring to: how is affected the data inserted
> in the new table by a trigger Before Insert compared with a trigger
> After Insert? and anything related to performance

See bottom of above page and here:

http://www.postgresql.org/docs/9.1/static/trigger-definition.html


>
> thank you
> have a sunny day
>


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

view thread (3+ messages)

Message-ID: <54621619.2040505@aklaver.com>
Permalink:  ../54621619.2040505@aklaver.com/
Also on:    postgresql.org/message-id/54621619.2040505@aklaver.com

copy link · copy postgr.es

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: pgsql-performance@postgresql.org
  Cc: adrian.klaver@aklaver.com, avprowebeden@gmail.com, pgsql-general@postgresql.org
  Subject: Re: trigger Before or After
  In-Reply-To: <54621619.2040505@aklaver.com>

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

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