pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: read commited
2+ messages / 2 participants
[nested] [flat]
* Re: read commited
@ 2003-08-25 14:43 Tom Lane <tgl@sss.pgh.pa.us>
2003-08-25 15:27 ` Re: read commited Dennis Björklund <db@zigo.dhs.org>
0 siblings, 1 reply; 2+ messages in thread
From: Tom Lane @ 2003-08-25 14:43 UTC (permalink / raw)
To: Dennis Björklund <db@zigo.dhs.org>; +Cc: pgsql-docs
=?ISO-8859-1?Q?Dennis_Bj=F6rklund?= <db@zigo.dhs.org> writes:
> The first part in the doc about concurrency with Read Commited
> transactions (12.2.1 in devel doc) it says:
> | Read Committed is the default isolation level in PostgreSQL.
> | When a transaction runs on this isolation level, a SELECT query
> | sees only data committed before the query began; it never sees
> | either uncommitted data or changes committed during query
> | execution by concurrent transactions.
> And that describes serializable transactions.
No, it doesn't. The critical phrase here is "data committed before the
*query* began" ... not "data committed before the *transaction* began".
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: read commited
2003-08-25 14:43 Re: read commited Tom Lane <tgl@sss.pgh.pa.us>
@ 2003-08-25 15:27 ` Dennis Björklund <db@zigo.dhs.org>
0 siblings, 0 replies; 2+ messages in thread
From: Dennis Björklund @ 2003-08-25 15:27 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-docs
On Mon, 25 Aug 2003, Tom Lane wrote:
> No, it doesn't. The critical phrase here is "data committed before the
> *query* began" ... not "data committed before the *transaction* began".
Aah, of course, it says query. Thanks (again).
--
/Dennis
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-08-25 15:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-08-25 14:43 Re: read commited Tom Lane <tgl@sss.pgh.pa.us>
2003-08-25 15:27 ` Dennis Björklund <db@zigo.dhs.org>
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