| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | SZŰCS Gábor <surrano(at)mailbox(dot)hu> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Delayed result from another connection |
| Date: | 2004-11-05 15:53:55 |
| Message-ID: | 26500.1099670035@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-sql |
=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?= <surrano(at)mailbox(dot)hu> writes:
> From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-11-05 16:02:28 | Re: Killed backend won't rollback transaction? |
| Previous Message | Markus Bertheau | 2004-11-05 15:50:59 | Re: pg_ctl telling only half the truth |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-11-05 16:02:28 | Re: Killed backend won't rollback transaction? |
| Previous Message | stuff | 2004-11-05 15:27:58 | oracle v$session equivalent in postgresql |