"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
pgsql-novice by date
|Next:||From: chrisj||Date: 2007-02-02 19:06:23|
|Subject: is there more documentation?|
|Previous:||From: Burak Seydioglu||Date: 2007-02-02 02:45:38|
|Subject: Is setQuerySnapshot called for embedded plpgsql function calls?|