pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedAfter insert trigger and select
4+ messages / 3 participants
[nested] [flat]
* After insert trigger and select
@ 2011-02-16 17:12 Rok Jaklič <rokj@rasca.net>
2011-02-16 19:46 ` Re: After insert trigger and select =?ISO-8859-2?Q?pasman_pasma=F1ski?= <pasman.p@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Rok Jaklič @ 2011-02-16 17:12 UTC (permalink / raw)
To: pgsql-sql
Hi.
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?
Thank you and kind regards,
Rok
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: After insert trigger and select
2011-02-16 17:12 After insert trigger and select Rok Jaklič <rokj@rasca.net>
@ 2011-02-16 19:46 ` =?ISO-8859-2?Q?pasman_pasma=F1ski?= <pasman.p@gmail.com>
2011-02-16 22:34 ` Re: After insert trigger and select Rok Jaklič <rokj@rasca.net>
0 siblings, 1 reply; 4+ messages in thread
From: pasman pasmański @ 2011-02-16 19:46 UTC (permalink / raw)
To: Rok Jaklič <rokj@rasca.net>; pgsql-sql
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: After insert trigger and select
2011-02-16 17:12 After insert trigger and select Rok Jaklič <rokj@rasca.net>
2011-02-16 19:46 ` Re: After insert trigger and select =?ISO-8859-2?Q?pasman_pasma=F1ski?= <pasman.p@gmail.com>
@ 2011-02-16 22:34 ` Rok Jaklič <rokj@rasca.net>
2011-02-17 16:37 ` Re: After insert trigger and select Igor Neyman <ineyman@perceptron.com>
0 siblings, 1 reply; 4+ messages in thread
From: Rok Jaklič @ 2011-02-16 22:34 UTC (permalink / raw)
To: pasman pasmański <pasman.p@gmail.com>; 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?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: After insert trigger and select
2011-02-16 17:12 After insert trigger and select Rok Jaklič <rokj@rasca.net>
2011-02-16 19:46 ` Re: After insert trigger and select =?ISO-8859-2?Q?pasman_pasma=F1ski?= <pasman.p@gmail.com>
2011-02-16 22:34 ` Re: After insert trigger and select Rok Jaklič <rokj@rasca.net>
@ 2011-02-17 16:37 ` Igor Neyman <ineyman@perceptron.com>
0 siblings, 0 replies; 4+ messages in thread
From: Igor Neyman @ 2011-02-17 16:37 UTC (permalink / raw)
To: Rok Jaklič <rokj@rasca.net>; pasman pasmański <pasman.p@gmail.com>; pgsql-sql
> -----Original Message-----
> From: Rok Jaklič [mailto:rokj@rasca.net]
> Sent: Wednesday, February 16, 2011 5:35 PM
> To: pasman pasmański; pgsql-sql
> Subject: Re: After insert trigger and select
>
> 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?
>
With MVCC "writers" don't block "readers", and "readers" don't block "writers".
Read PG docs on MVCC.
Regards,
Igor Neyman
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2011-02-17 16:37 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-02-16 17:12 After insert trigger and select Rok Jaklič <rokj@rasca.net>
2011-02-16 19:46 ` =?ISO-8859-2?Q?pasman_pasma=F1ski?= <pasman.p@gmail.com>
2011-02-16 22:34 ` Rok Jaklič <rokj@rasca.net>
2011-02-17 16:37 ` Igor Neyman <ineyman@perceptron.com>
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