Re: Alter Table + Default Value + Serializable - Mailing list pgsql-general

From Sébastien Lardière
Subject Re: Alter Table + Default Value + Serializable
Date
Msg-id 4CD424A1.80800@hi-media.com
Whole thread Raw
In response to Alter Table + Default Value + Serializable  (Sébastien Lardière <slardiere@hi-media.com>)
List pgsql-general
On 11/05/2010 04:28 PM, Sébastien Lardière wrote:
> Hi,
>
> I've got a problem with a query run on production system. We've got some
> data export in a serializable transaction, and, 2 days ago, someone ran
> a DDL ( alter table foo add column ba test default 'blabla'), and then,
> the data export is empty. I try to reproduce the scenario below :

I forgot to mention that this scenario works with 8.3 and 9.0.

--
Sébastien


pgsql-general by date:

Previous
From: Sébastien Lardière
Date:
Subject: Alter Table + Default Value + Serializable
Next
From: John R Pierce
Date:
Subject: Re: Cloning database without dump/restore