Re: Alter Table + Default Value + Serializable

From: Sébastien Lardière <slardiere(at)hi-media(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Alter Table + Default Value + Serializable
Date: 2010-11-05 15:37:05
Message-ID: 4CD424A1.80800@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2010-11-05 15:53:08 Re: Cloning database without dump/restore
Previous Message Sébastien Lardière 2010-11-05 15:28:06 Alter Table + Default Value + Serializable