Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YjFoV-0006xt-Qx for pgsql-docs@arkaria.postgresql.org; Fri, 17 Apr 2015 23:36:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YjFoV-0003mA-6n for pgsql-docs@arkaria.postgresql.org; Fri, 17 Apr 2015 23:36:47 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YjFoT-0003lw-RC for pgsql-docs@postgresql.org; Fri, 17 Apr 2015 23:36:46 +0000 Received: from mail-ig0-x22c.google.com ([2607:f8b0:4001:c05::22c]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YjFoP-0008CH-Jn for pgsql-docs@postgresql.org; Fri, 17 Apr 2015 23:36:43 +0000 Received: by igblo3 with SMTP id lo3so24035832igb.1 for ; Fri, 17 Apr 2015 16:36:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=y0dso9x7Rysk8WJDVtZOZlaC6O1wrP8NtyOF44YdgMI=; b=gg8XqUp2Kcl8BTBQj36iq5afAmfnimiCrHachp+NSsXmgZKKSXqmKrnULqJ1hb8CZv bj/MpNMtFEIM6WKLyHTOWeI4Os8rF84Qp4bT06TYIagTqM1VXoaL5ovgDaxVTa58ZYM4 QQJ4hXbi2kn3mGQ07xSQHZAFwR8p1fjEEIbKVGf21WIvzFJDundPdGrwoYuhJldpR1qI YZ1RMXJ5aBml1Suc63OTxLU/iv4Szc8pKQVkZnuy3V4Ul92+ktcdXah8+C7vf9MZr9WA 5CaEPpgxXxrsAEt36MxhGlSElskRLwj7HMDD71p7vsaDDGd++wNF4H2JXqY7aZj71N9O OYqQ== MIME-Version: 1.0 X-Received: by 10.50.41.8 with SMTP id b8mr6114763igl.38.1429313800867; Fri, 17 Apr 2015 16:36:40 -0700 (PDT) Received: by 10.36.64.15 with HTTP; Fri, 17 Apr 2015 16:36:40 -0700 (PDT) In-Reply-To: References: <20150416012128.GB1672@momjian.us> Date: Fri, 17 Apr 2015 16:36:40 -0700 Message-ID: Subject: Re: Add a new table for Transaction Isolation? From: "David G. Johnston" To: Bruce Momjian Cc: "pgsql-docs@postgresql.org" Content-Type: multipart/mixed; boundary=089e0116197a5fb21c0513f40d10 X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org --089e0116197a5fb21c0513f40d10 Content-Type: multipart/alternative; boundary=089e0116197a5fb2170513f40d0e --089e0116197a5fb2170513f40d0e Content-Type: text/plain; charset=UTF-8 A bit of scope creep due to wanting to point out the obvious "RR and SER" are the same observation on the table. The main body for SER covers the fact as well though in a very technical way. I thought pointing out that examples are on the Wiki would be useful as well - not everyone would think to go there for additional information. No like though - just a pointer to it or the Internet generally. It is not obvious to me what means...I suspect 1=yes... David J. On Wed, Apr 15, 2015 at 6:26 PM, David G. Johnston < david.g.johnston@gmail.com> wrote: > On Wednesday, April 15, 2015, Bruce Momjian wrote: > >> On Mon, Apr 13, 2015 at 08:00:38PM -0700, David G. Johnston wrote: >> > http://www.postgresql.org/docs/9.4/static/transaction-iso.html >> > >> > Table 13-1 shows the SQL standard isolation levels and what is and is >> not >> > guaranteed. Then the text goes on to explain how our implementation >> differs >> > from that table. Is there any opposition to actually adding a similar >> table, >> > 13-2, probably right after the paragraph, with the same columns, three >> rows, >> > and the corresponding possible/not-possible cell values? >> >> Yes, it does make sense to have a table that properly matches the >> Postgres implementation. Should I write a patch or would you like to? >> >> > I'll take a crack at it. > > David J. > --089e0116197a5fb2170513f40d0e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
A bit of scope creep due to wanting to point out the ob= vious "RR and SER" are the same observation on the table.=C2=A0 T= he main body for SER covers the fact as well though in a very technical way= .

I thought pointing out that examples are on the Wiki= would be useful as well - not everyone would think to go there for additio= nal information.=C2=A0 No like though - just a pointer to it or the Interne= t generally.

It is not obvious to me what <table to= centry=3D"1"> means...I suspect 1=3Dyes...

<= div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif= ">David J.

On Wed, Apr 15, 2015 at 6:26 PM, David G. Johnston <david= .g.johnston@gmail.com> wrote:
On Wednesday, April 15, 2015, Bruce Momjian <bruce@momjian.us> wro= te:
On Mon, Apr 13, 2015 at 08:00:38PM -0= 700, David G. Johnston wrote:
> http://www.postgresql.org/docs/9.4/static/transactio= n-iso.html
>
> Table 13-1 shows the SQL standard isolation levels and what is and is = not
> guaranteed.=C2=A0 Then the text goes on to explain how our implementat= ion differs
> from that table.=C2=A0 Is there any opposition to actually adding a si= milar table,
> 13-2, probably right after the paragraph, with the same columns, three= rows,
> and the corresponding possible/not-possible cell values?

Yes, it does make sense to have a table that properly matches the
Postgres implementation.=C2=A0 =C2=A0Should I write a patch or would you li= ke to?


I'll take a crack at it.
<= div>
David J.=C2=A0

--089e0116197a5fb2170513f40d0e-- --089e0116197a5fb21c0513f40d10 Content-Type: text/plain; charset=US-ASCII; name="mvcc-isolationlevels-v1.diff" Content-Disposition: attachment; filename="mvcc-isolationlevels-v1.diff" Content-Transfer-Encoding: base64 X-Attachment-Id: f_i8m8ekbh0 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9tdmNjLnNnbWwgYi9kb2Mvc3Jj L3NnbWwvbXZjYy5zZ21sCmluZGV4IGY4OGIxNmUuLjUwMDIxMzggMTAwNjQ0 Ci0tLSBhL2RvYy9zcmMvc2dtbC9tdmNjLnNnbWwKKysrIGIvZG9jL3NyYy9z Z21sL212Y2Muc2dtbApAQCAtMTAwLDYgKzEwMCwxNCBAQAogICAgIHBoZW5v bWVuYSBjYXVzZWQgYnkgaW50ZXJhY3Rpb25zPykKICAgIDwvcGFyYT4KIAor ICA8cGFyYT4KKyAgIFRoZSBjb25jZXB0cyBjb3ZlcmVkIGluIHRoaXMgc2Vj dGlvbiBhcmUKKyAgIHByZXNlbnRlZCB3aXRob3V0IGV4YW1wbGVzIG9mIHRo ZSBiZWhhdmlvcnMgZGVzY3JpYmVkLiAgVGhlIGludGVybmV0LAorICAgaW5j bHVkaW5nIGFuZCBlc3BjaWFsbHkgdGhlIDxwcm9kdWN0bmFtZT5Qb3N0Z3Jl U1FMPC9wcm9kdWN0bmFtZT4gV2lraSwgaXMKKyAgIGFuIGV4Y2VsbGVudCBy ZXNvdXJjZSB0byBsZWFybiBtb3JlIGFib3V0IGNpcmN1bXN0YW5jZXMgdW5k ZXIgd2hpY2ggdGhlc2UKKyAgIGRhdGEgcGhlbm9tZW5hIG9jY3VyLCBhbmQg d2hhdCB0aGUgcmVzdWx0cyBsb29rIGxpa2Ugd2hlbiB0aGV5IGRvLgorICA8 L3BhcmE+CisKICAgIDxwYXJhPgogICAgIFRoZSBwaGVub21lbmEgd2hpY2gg YXJlIHByb2hpYml0ZWQgYXQgdmFyaW91cyBsZXZlbHMgYXJlOgogCkBAIC0x NTAsMTIgKzE1OCwxMiBAQAogICAgIDxpbmRleHRlcm0+CiAgICAgIDxwcmlt YXJ5PnRyYW5zYWN0aW9uIGlzb2xhdGlvbiBsZXZlbDwvcHJpbWFyeT4KICAg ICA8L2luZGV4dGVybT4KLSAgICBUaGUgZm91ciB0cmFuc2FjdGlvbiBpc29s YXRpb24gbGV2ZWxzIGFuZCB0aGUgY29ycmVzcG9uZGluZwotICAgIGJlaGF2 aW9ycyBhcmUgZGVzY3JpYmVkIGluIDx4cmVmIGxpbmtlbmQ9Im12Y2MtaXNv bGV2ZWwtdGFibGUiPi4KKyAgICBUaGUgZm91ciBTUUwgdHJhbnNhY3Rpb24g aXNvbGF0aW9uIGxldmVscywgYW5kIHRoZWlyIGNvcnJlc3BvbmRpbmcKKyAg ICBiZWhhdmlvcnMsIGFyZSBkZXNjcmliZWQgaW4gPHhyZWYgbGlua2VuZD0i bXZjYy1pc29sZXZlbC10YWJsZSI+LgogICAgPC9wYXJhPgogCiAgICAgPHRh YmxlIHRvY2VudHJ5PSIxIiBpZD0ibXZjYy1pc29sZXZlbC10YWJsZSI+Ci0g ICAgIDx0aXRsZT5TdGFuZGFyZCA8YWNyb255bT5TUUw8L2Fjcm9ueW0+IFRy YW5zYWN0aW9uIElzb2xhdGlvbiBMZXZlbHM8L3RpdGxlPgorICAgICA8dGl0 bGU+PGFjcm9ueW0+U1FMPC9hY3JvbnltPiBTdGFuZGFyZCBUcmFuc2FjdGlv biBJc29sYXRpb24gTGV2ZWxzPC90aXRsZT4KICAgICAgPHRncm91cCBjb2xz PSI0Ij4KICAgICAgIDx0aGVhZD4KICAgICAgICA8cm93PgpAQCAtMjU2LDYg KzI2NCw4OSBAQAogICAgPC9wYXJhPgogCiAgICA8cGFyYT4KKyAgICBUaGUg dGhyZWUgPHByb2R1Y3RuYW1lPlBvc3RncmVTUUw8L3Byb2R1Y3RuYW1lPiB0 cmFuc2FjdGlvbiBpc29sYXRpb24gbGV2ZWxzLCBhbmQgdGhlaXIgY29ycmVz cG9uZGluZworICAgIGJlaGF2aW9ycywgYXJlIGRlc2NyaWJlZCBpbiA8eHJl ZiBsaW5rZW5kPSJtdmNjLXBnc3FsLWlzb2xldmVsLXRhYmxlIj4uCisgICA8 L3BhcmE+CisKKyAgICA8dGFibGUgdG9jZW50cnk9IjEiIGlkPSJtdmNjLXBn c3FsLWlzb2xldmVsLXRhYmxlIj4KKyAgICAgPHRpdGxlPjxwcm9kdWN0bmFt ZT5Qb3N0Z3JlU1FMPC9wcm9kdWN0bmFtZT4gVHJhbnNhY3Rpb24gSXNvbGF0 aW9uIExldmVsczwvdGl0bGU+CisgICAgIDx0Z3JvdXAgY29scz0iNCI+Cisg ICAgICA8dGhlYWQ+CisgICAgICAgPHJvdz4KKyAgICAgICAgPGVudHJ5Pgor ICAgICAgICAgSXNvbGF0aW9uIExldmVsCisgICAgICAgIDwvZW50cnk+Cisg ICAgICAgIDxlbnRyeT4KKyAgICAgICAgIERpcnR5IFJlYWQKKyAgICAgICAg PC9lbnRyeT4KKyAgICAgICAgPGVudHJ5PgorICAgICAgICAgTm9ucmVwZWF0 YWJsZSBSZWFkCisgICAgICAgIDwvZW50cnk+CisgICAgICAgIDxlbnRyeT4K KyAgICAgICAgIFBoYW50b20gUmVhZAorICAgICAgICA8L2VudHJ5PgorICAg ICAgIDwvcm93PgorICAgICAgPC90aGVhZD4KKyAgICAgIDx0Ym9keT4KKyAg ICAgICA8cm93PgorICAgICAgICA8ZW50cnk+CisgICAgICAgICBSZWFkIGNv bW1pdHRlZAorICAgICAgICA8L2VudHJ5PgorICAgICAgICA8ZW50cnk+Cisg ICAgICAgICBOb3QgcG9zc2libGUKKyAgICAgICAgPC9lbnRyeT4KKyAgICAg ICAgPGVudHJ5PgorICAgICAgICAgUG9zc2libGUKKyAgICAgICAgPC9lbnRy eT4KKyAgICAgICAgPGVudHJ5PgorICAgICAgICAgUG9zc2libGUKKyAgICAg ICAgPC9lbnRyeT4KKyAgICAgICA8L3Jvdz4KKworICAgICAgIDxyb3c+Cisg ICAgICAgIDxlbnRyeT4KKyAgICAgICAgIFJlcGVhdGFibGUgcmVhZAorICAg ICAgICA8L2VudHJ5PgorICAgICAgICA8ZW50cnk+CisgICAgICAgICBOb3Qg cG9zc2libGUKKyAgICAgICAgPC9lbnRyeT4KKyAgICAgICAgPGVudHJ5Pgor ICAgICAgICAgTm90IHBvc3NpYmxlCisgICAgICAgIDwvZW50cnk+CisgICAg ICAgIDxlbnRyeT4KKyAgICAgICAgIE5vdCBQb3NzaWJsZQorICAgICAgICA8 L2VudHJ5PgorICAgICAgIDwvcm93PgorCisgICAgICAgPHJvdz4KKyAgICAg ICAgPGVudHJ5PgorICAgICAgICAgU2VyaWFsaXphYmxlCisgICAgICAgIDwv ZW50cnk+CisgICAgICAgIDxlbnRyeT4KKyAgICAgICAgIE5vdCBwb3NzaWJs ZQorICAgICAgICA8L2VudHJ5PgorICAgICAgICA8ZW50cnk+CisgICAgICAg ICBOb3QgcG9zc2libGUKKyAgICAgICAgPC9lbnRyeT4KKyAgICAgICAgPGVu dHJ5PgorICAgICAgICAgTm90IHBvc3NpYmxlCisgICAgICAgIDwvZW50cnk+ CisgICAgICAgPC9yb3c+CisgICAgICA8L3Rib2R5PgorICAgICA8L3Rncm91 cD4KKyAgICA8L3RhYmxlPgorCisgICA8cGFyYT4KKyAgICBBcyB0aGUgdGFi bGUgbWFrZXMgY2xlYXIgdGhlcmUgaXMgbm8gZGlmZmVyZW5jZSBpbiB0aGUg cG90ZW50aWFsIHBoZW5vbWVuYQorICAgIGF0IHRoZSBSRVBFQVRBQkxFIFJF QUQgYW5kIFNFUklBTElaQUJMRSB0cmFuc2FjdGlvbiBpc29sYXRpb24gbGV2 ZWxzOyBidXQKKyAgICB0aGUgcGhlbm9tZW5hIGxpc3RlZCBvbmx5IHBlcnRh aW4gdG8gdGhlIGRhdGEgc2VlbiBieSB0aGUgdHJhbnNhY3Rpb24uCisgICAg VGhlIGRpZmZlcmVuY2UgaXMgdGhhdCBSRVBFQVRBQkxFIFJFQUQgd2lsbCBv bmx5IHNlcmlhbC1mYWlsCisgICAgaWYgdHdvIHRyYW5zYWN0aW9ucyBhdHRl bXB0IHRvIG1vZGlmeSB0aGUgc2FtZSByZWNvcmQgd2hpbGUgU0VSSUFMSVpB QkxFIHdpbGwgCisgICAgYWxzbyBzZXJpYWwtZmFpbCBpZiBvbmUgdHJhbnNh Y3Rpb24gbW9kaWZpZXMgYSByZWNvcmQgdGhhdCBhbm90aGVyIHRyYW5zYWN0 aW9uIAorICAgIGhhcyBvbmx5IHJlYWQuCisgICA8L3BhcmE+CisgICAKKyAg IDxwYXJhPgogICAgIFRvIHNldCB0aGUgdHJhbnNhY3Rpb24gaXNvbGF0aW9u IGxldmVsIG9mIGEgdHJhbnNhY3Rpb24sIHVzZSB0aGUKICAgICBjb21tYW5k IDx4cmVmIGxpbmtlbmQ9InNxbC1zZXQtdHJhbnNhY3Rpb24iPi4KICAgIDwv cGFyYT4K --089e0116197a5fb21c0513f40d10 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --089e0116197a5fb21c0513f40d10--