Postgres Pro
Downloads
Home   >   mailing lists

Re: Table lock while adding a column and clients are logged in - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Table lock while adding a column and clients are logged in
Date
Msg-id 1AB590A7-8245-42C0-AF30-96206D9DBE41@solfertje.student.utwente.nl
Whole thread Raw
In response to Re: Table lock while adding a column and clients are logged in  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Responses Re: Table lock while adding a column and clients are logged in
List pgsql-general
Tree view 
On 3 Apr 2011, at 11:22, Alban Hertroys wrote:

> Oracle and SQL server don't "suffer" from this because they do not handle DDL statements transactionally (I could be
mistakenabout SQL server, I don't know it all that well). 


I forgot to mention, if you perform DDL in Oracle all your currently running transactions are implicitly rolled back.
Thatmay be something you want to be aware of. 

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4d983e5e651347237915052!

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Table lock while adding a column and clients are logged in
Next
From: "Henry C."
Date:
Subject: Re: Autovacuum firing up during my manual vacuum on same table