Re: [SQL] Delayed result from another connection

2004-11-05 Thread Tom Lane
=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?= <[EMAIL PROTECTED]> writes: > From: "Tom Lane" <[EMAIL PROTECTED]> >> 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 tran

Re: [SQL] Delayed result from another connection

2004-11-05 Thread SZŰCS Gábor
Dear Tom, Thanks for the explanation, it's more than enough. Some more questions if you don't mind: - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> Sent: Thursday, November 04, 2004 6:46 PM > =?iso-8859-2?B?U1rbQ1MgR+Fib3I=?= <[EMAIL PROTECTED]> writes: > > The php connects t

Re: [SQL] Delayed result from another connection

2004-11-04 Thread Tom Lane
=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?= <[EMAIL PROTECTED]> writes: > The php connects to the database and updates retval where id=seq. > It seems to be OK, but the function returns the value of php_retval.retval > _before_ the call. Yes, because your transaction is working with a database snapshot that

[SQL] Delayed result from another connection

2004-11-04 Thread SZŰCS Gábor
Dear Gurus, I have a strange scenario that doesn't seem to work flawlessly. I think I can produce a full working example if needed. We use postgresql 7.4.5 It's something like this: %--- cut here ---% CREATE TABLE php_retval(id serial PRIMARY KEY, retval v