Skip site navigation (1) Skip section navigation (2)

Re: Is setQuerySnapshot called for embedded plpgsql function calls?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Burak Seydioglu" <buraks78(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Is setQuerySnapshot called for embedded plpgsql function calls?
Date: 2007-02-02 03:40:07
Message-ID: 14454.1170387607@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"Burak Seydioglu" <buraks78(at)gmail(dot)com> writes:
> For some reason, the consecutive second_func() calls do not see the
> newly inserted data. So the total for the next second_func() call
> always remains zero. Please see the code below.

> Is this because setQuerySnapshot() is not called for embedded plpgsql
> functions but only for the first_function() call?

For operations within a single transaction, what counts is
CommandCounterIncrement not SetQuerySnapshot.

> I am runnging 7.4 btw.

I believe we changed the rules for this in 8.0 ... can you upgrade?

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: chrisjDate: 2007-02-02 19:06:23
Subject: is there more documentation?
Previous:From: Burak SeydiogluDate: 2007-02-02 02:45:38
Subject: Is setQuerySnapshot called for embedded plpgsql function calls?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group