Date: Sat, 25 Apr 2015 16:02:55 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Kevin Grittner <kgrittn@ymail.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
 Peter Eisentraut <peter_e@gmx.net>,
 "pgsql-docs@postgresql.org" <pgsql-docs@postgresql.org>
Subject: Re: Add a new table for Transaction Isolation?
Message-ID: <20150425200255.GD17791@momjian.us>
References: <20150425191617.GC17791@momjian.us>
 <112988831.4359293.1429991135817.JavaMail.yahoo@mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <112988831.4359293.1429991135817.JavaMail.yahoo@mail.yahoo.com>
User-Agent: Mutt/1.5.20 (2009-06-14)
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

On Sat, Apr 25, 2015 at 07:45:35PM +0000, Kevin Grittner wrote:
> They never use the word anomaly (or its plural) in the standard
> (even though it is prevalent in the academic literature).  See my
> earlier email for examples of how the standard describes the issue,
> but basically it just boils down to saying that the effects of
> concurrent execution of a set of serializable transactions must be
> consistent with some one-at-a-time execution order.  We could
> perhaps have the column header say "Non-Serializable Behavior" or
> some such; but I think we need to define whatever term we use for
> the new column header.

I don't think we can define the column as a negative, e.g. "Non-".

> >> ​Pondering whether something like: "Possible (not in PG)" and
> >> avoiding the additional rows would make reading the table
> >> easier.
> >
> > Uh, that's an idea.  I thought visually having two separate lines
> > was cleaner.
> 
> I think one row per transaction isolation level, with three
> possible values per cell, would be the cleanest.  I have been
> trying to think of alternatives for the three values, but have not
> come up with anything better than David's suggestion.

Well, then "Possible" would refer to the SQL standard behavior, which
seems kind of an odd thing to emphasize there.  The field really needs
to be "SQL-standard possible, PostgreSQL not possible", but that is too
long.  This is why I split it into separate lines.  We could try
"Possible (SQL standard), Not possible (PostgreSQL)".

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs