Re: After insert trigger and select - Mailing list pgsql-sql

From Rok Jaklič
Subject Re: After insert trigger and select
Date
Msg-id 4D5C50FE.90507@rasca.net
Whole thread Raw
In response to Re: After insert trigger and select  (pasman pasmański <pasman.p@gmail.com>)
Responses Re: After insert trigger and select  ("Igor Neyman" <ineyman@perceptron.com>)
List 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?



pgsql-sql by date:

Previous
From: pasman pasmański
Date:
Subject: Re: After insert trigger and select
Next
From: "Gnanakumar"
Date:
Subject: Is it possible to get DISTINCT rows from RETURNING clause?