Re: When is newly inserted data visible to another connection?

From: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
To: fkater(at)googlemail(dot)com
Cc: pgsql-general Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: When is newly inserted data visible to another connection?
Date: 2010-08-18 13:21:47
Message-ID: 8801417C-4E43-49FA-AE64-AA958E9F26C8@killerbytes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Aug 18, 2010, at 6:57 AM, fkater(at)googlemail(dot)com wrote:

> Even in pure serialization it should be possible
> that client 2 can immediately start reading *after* client 1
> has completely commited, shouldn't it?

Unless client 2 had previously started a transaction and is reading from that.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2010-08-18 13:35:27 Re: Windows 2003 server installation issue
Previous Message fkater@googlemail.com 2010-08-18 12:57:53 Re: When is newly inserted data visible to another connection?