Postgres Pro
Downloads
Home   >   mailing lists

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

From Thomas Kellerer
Subject Re: Table lock while adding a column and clients are logged in
Date
Msg-id in9t0v$ne2$1@dough.gmane.org
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>)
List pgsql-general
Tree view 
Alban Hertroys wrote on 03.04.2011 11:31:
> 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 mistaken about
>> 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.

Not quite. The current transaction is committed, not rolled back.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_1001.htm#i2099120

Regards
Thomas

pgsql-general by date:

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