Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YiYZB-0006Nt-Rh for pgsql-docs@arkaria.postgresql.org; Thu, 16 Apr 2015 01:26:05 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YiYZB-0003ph-BJ for pgsql-docs@arkaria.postgresql.org; Thu, 16 Apr 2015 01:26:05 +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 1YiYZA-0003pX-Iz for pgsql-docs@postgresql.org; Thu, 16 Apr 2015 01:26:04 +0000 Received: from mail-ie0-x22d.google.com ([2607:f8b0:4001:c03::22d]) by makus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YiYZ7-0007Vc-5e for pgsql-docs@postgresql.org; Thu, 16 Apr 2015 01:26:02 +0000 Received: by iecrt8 with SMTP id rt8so28762569iec.0 for ; Wed, 15 Apr 2015 18:26:00 -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=GnUn0y9YAX66hdeuy9dJPEsJuSMuKa8f/5UQ76Q1aoI=; b=JMANAG0Csk9DPa56g1ZqHzDJRraSiQEGPxThc7li8cKylXWAc/3sCHeN7MfiujJ3Yx 4T0GX04zhLU+OgXRDyFTB0fFhj3msK7MDl/Cy/l64CWxa7ySCp95r8N1GRdsLutBin5x +MsP+vDNx4uhjFPB+6c5nDbd++ZjBi6RbgYQyZSTXvzrHiRpJEOF5/KsOYthsrw+DH7Y S5FGwtbQIfP4MuYfxPZewBHdrq7uIhP79B4h2mLjO+/qax0S4AsOZ9Cipv70CtM7CxLd jHkEJD9Kt96p4vn/Vm7h+gwWtNJYmVfvaua1SzsKJQ5SiE/DmSMWiz6cCixrdSHuT4kG 3FbA== MIME-Version: 1.0 X-Received: by 10.42.0.9 with SMTP id 9mr34870336ica.49.1429147560432; Wed, 15 Apr 2015 18:26:00 -0700 (PDT) Received: by 10.36.64.15 with HTTP; Wed, 15 Apr 2015 18:26:00 -0700 (PDT) In-Reply-To: <20150416012128.GB1672@momjian.us> References: <20150416012128.GB1672@momjian.us> Date: Wed, 15 Apr 2015 18:26:00 -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/alternative; boundary=001a11c3aa56ac01ed0513cd58c6 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 --001a11c3aa56ac01ed0513cd58c6 Content-Type: text/plain; charset=UTF-8 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. --001a11c3aa56ac01ed0513cd58c6 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Wednesday, April 15, 2015, Bruce Momjian <bruce@momjian.us> wrote:
= On Mon, Apr 13, 2015 at 08:00:38PM -0700, 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.
David J.=C2=A0
--001a11c3aa56ac01ed0513cd58c6--