Re: Strange Behavior with Serializable Transcations

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Strange Behavior with Serializable Transcations
Date: 2006-06-28 20:20:12
Message-ID: 20060628202012.GA15428@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 28, 2006 at 14:48:01 -0400,
Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info> wrote:
> I'm seeing something fairly unintuitive about serializable transactions.
>
> "When a transaction is on the serializable level, a SELECT query sees
> only data committed before the transaction began; it never sees either
> uncommitted data or changes committed during transaction execution by
> concurrent transactions."

This has come up on the lists before. Take a look at:
http://secure.linuxports.com/pgsql-admin/2006-01/msg00256.php

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-06-28 20:43:41 Re: unusual "relation xxx does not exist" problem
Previous Message Leif B. Kristensen 2006-06-28 20:16:23 Re: empty text fields