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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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