From: Tom Lane <tgl@sss.pgh.pa.us>
To: SZŰCS Gábor <surrano@mailbox.hu>
Cc: pgsql-sql@postgresql.org
Subject: Re: Delayed result from another connection
Date: Fri, 05 Nov 2004 10:53:55 -0500
Message-ID: <26500.1099670035@sss.pgh.pa.us> (raw)
In-Reply-To: <011201c4c33b$7bd722c0$0403a8c0@fejleszt4>
References: <012601c4c292$6804b810$0403a8c0@fejleszt4>
<26896.1099590388@sss.pgh.pa.us>
<011201c4c33b$7bd722c0$0403a8c0@fejleszt4>
=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?= <surrano@mailbox.hu> writes:
> From: "Tom Lane" <tgl@sss.pgh.pa.us>
>> Yes, because your transaction is working with a database snapshot that
>> predates the other transaction run by the separate PHP connection.
> Yes, but the snapshot is not constant during a transaction, right?
In pre-8.0 releases, the snapshot only advances between interactive
commands, not between commands of a function; so you can't see the
results of other transactions that commit after the function starts.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, surrano@mailbox.hu
Subject: Re: Delayed result from another connection
In-Reply-To: <26500.1099670035@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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