Re: After insert trigger and select

From: Rok Jaklič <rokj(at)rasca(dot)net>
To: pasman pasmański <pasman(dot)p(at)gmail(dot)com>, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: After insert trigger and select
Date: 2011-02-16 22:34:38
Message-ID: 4D5C50FE.90507@rasca.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 02/16/2011 08:46 PM, pasman pasmański wrote:
>> If I have after insert trigger on some table which updates some data in
>> that same table, will be the select statement from some other client
>> executed after all statements in that trigger?
>>
> select statement is fired before commit ?
> ------------
> pasman
For example let us say that trigger takes a long time to end. Are all
statements in trigger executed before select from "outside" if select is
called somewhere between executing of the trigger?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gnanakumar 2011-02-17 07:05:51 Is it possible to get DISTINCT rows from RETURNING clause?
Previous Message pasman pasmański 2011-02-16 19:46:05 Re: After insert trigger and select