Skip site navigation (1) Skip section navigation (2)

Re: incoherent view of serializable transactions

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>,<pgsql-hackers(at)postgresql(dot)org>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: incoherent view of serializable transactions
Date: 2008-12-29 15:27:51
Message-ID: 49589817.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackers
>>> Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> Serializability is not defined in terms of what is visible, but what
the 
> state of the database is.
 
A belated thought on this: It would be easy enough to add a
daily_receipt_total table to the example to capture the result of the
query, instead of assuming that it merely prints on the daily bank
deposit report.  That would certainly meet your test of ending with an
invalid database state after all the transactions commit.
 
-Kevin

In response to

pgsql-hackers by date

Next:From: Aidan Van DykDate: 2008-12-29 15:51:40
Subject: Re: Several tags around PostgreSQL 7.1 broken
Previous:From: Kevin GrittnerDate: 2008-12-29 15:16:42
Subject: Re: incoherent view of serializable transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group