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

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Table lock while adding a column and clients are logged in
Date: 2011-04-03 13:34:23
Message-ID: in9t0v$ne2$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2011-04-03 13:37:17 Re: Table lock while adding a column and clients are logged in
Previous Message Henry C. 2011-04-03 10:03:39 Re: Autovacuum firing up during my manual vacuum on same table