From:
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To:
"Peter Eisentraut" <peter_e(at)gmx(dot)net>,"Kevin Grittner" <Kgrittn(dot)CCAP(dot)Courts(at)wicourts(dot)gov>
Cc:
"Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>,"Gregory Stark" <stark(at)enterprisedb(dot)com>,"Emmanuel Cecchet" <manu(at)frogthinker(dot)org>,<pgsql-hackers(at)postgresql(dot)org>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject:
Re: incoherent view of serializable transactions
Date:
2009-01-08 14:45:25
Message-ID:
4965BD25.EE98.0025.0@wicourts.gov (view raw or flat )
Thread:
2008-12-22 17:00:53 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-22 17:54:59 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2008-12-22 18:37:45 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 04:44:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2008-12-23 14:51:03 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 14:59:30 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
2008-12-23 15:14:36 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 15:47:37 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2008-12-23 16:10:05 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 20:55:47 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2008-12-23 21:11:00 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-31 00:33:26 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-01-03 22:06:14 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-01-03 22:53:51 from Gregory Stark <stark(at)enterprisedb(dot)com>
2009-01-03 23:37:09 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-01-05 14:51:29 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-01-07 13:17:49 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2009-01-07 15:40:02 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-01-08 14:45:25 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-01-22 03:00:16 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 16:12:09 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-12-23 16:27:57 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 17:04:11 from Gregory Stark <stark(at)enterprisedb(dot)com>
2008-12-23 17:24:51 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 17:15:38 from Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
2008-12-23 17:58:29 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-23 20:46:39 from "Robert Haas" <robertmhaas(at)gmail(dot)com>
2008-12-23 21:06:01 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-24 23:46:17 from Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
2008-12-24 23:53:35 from Robert Haas <robertmhaas(at)gmail(dot)com>
2008-12-29 12:20:34 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2008-12-29 15:16:42 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-29 15:27:51 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2008-12-29 17:21:12 from Greg Stark <greg(dot)stark(at)enterprisedb(dot)com>
2008-12-30 08:56:43 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2008-12-30 17:28:01 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2009-01-03 22:20:10 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2008-12-23 05:42:06 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
2008-12-23 18:48:52 from Jeff Davis <pgsql(at)j-davis(dot)com>
2008-12-23 23:44:53 from Emmanuel Cecchet <manu(at)frogthinker(dot)org>
Lists:
pgsql-hackers
>>> I wrote:
>>>> Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
>> Kevin Grittner wrote:
>>>> "is a natural consequence of the fact" --- There is nothing
>>>> natural about any of this. Why is it a consequence and how?
>>>
>>> How could you possibly get any of those phenomena if there are no
>>> concurrent transactions?
>>
>> I see what you mean now, but you could write out that logic in more
>> detail.
>
> Those weren't my words; I was quoting the SQL spec.
Last night I was reviewing my proposed patch from this thread, to try
to address other expressed concerns, and noticed that I had used this
language from the SQL spec in the patch. I see your point now.
Without the same context as the spec, and when intended for a
different audience, this language probably isn't the best. It now
also occurs to me that the spec is a copyrighted work, and it probably
isn't appropriate to copy a chunk that big into PostgreSQL docs.
I'll write something in my own words to replace this.
Thanks for the input, and sorry for misunderstanding.
-Kevin
In response to
pgsql-hackers by date
Next :From: D'Arcy J.M. CainDate: 2009-01-08 15:15:31
Subject : Re: Proposal: new border setting in psql
Previous :From : Tom LaneDate : 2009-01-08 14:44:14
Subject : Re: ONLY with parentheses