Re: Table lock while adding a column and clients are logged in

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: Table lock while adding a column and clients are logged in
Дата
Msg-id 1AB590A7-8245-42C0-AF30-96206D9DBE41@solfertje.student.utwente.nl
обсуждение исходный текст
Ответ на Re: Table lock while adding a column and clients are logged in  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
Ответы Re: Table lock while adding a column and clients are logged in  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Table lock while adding a column and clients are logged in
Следующее
От: "Henry C."
Дата:
Сообщение: Re: Autovacuum firing up during my manual vacuum on same table