Re: ALTER TABLE SET STATISTICS requires AccessExclusiveLock - Mailing list pgsql-hackers

From Andres Freund
Subject Re: ALTER TABLE SET STATISTICS requires AccessExclusiveLock
Date
Msg-id 201007162110.07216.andres@anarazel.de
Whole thread Raw
In response to Re: ALTER TABLE SET STATISTICS requires AccessExclusiveLock  (Andres Freund <andres@anarazel.de>)
Responses Re: ALTER TABLE SET STATISTICS requires AccessExclusiveLock
List pgsql-hackers
On Friday 16 July 2010 20:41:44 Andres Freund wrote:
> >> !                     */
> >> !                    case AT_AddColumn:                      /* may
> >> rewrite heap, in some cases and visible to SELECT */ !
> >>                    case AT_DropColumn:                     /* change
> >> visible to SELECT */ !                    case
> >> AT_AddColumnToView:        /* CREATE VIEW */ !                    case
> >> AT_AlterColumnType:        /* must rewrite heap */ !
> >>                    case AT_DropConstraint:         /* as DROP INDEX */
> >> !                    case AT_AddOids:
> >> !                    case AT_DropOids:                       /* calls
> >> AT_DropColumn */ !                    case
> >> AT_EnableAlwaysRule:       /* as DROP INDEX */ !
> >>                    case AT_EnableReplicaRule:      /* as DROP INDEX */
> >> !                    case AT_EnableRule:                     /* as DROP
> >> INDEX */
Another remark:

Imho it would be usefull to keep that list in same order as in the enum - 
currently its hard to make sure no case is missing.

Andres


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: patch (for 9.1) string functions
Next
From: Simon Riggs
Date:
Subject: Re: ALTER TABLE SET STATISTICS requires AccessExclusiveLock