SZŰCS Gábor <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