| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Subject: | Re: ALTER TABLE SET STATISTICS requires AccessExclusiveLock |
| Date: | 2010-07-16 19:10:06 |
| Message-ID: | 201007162110.07216.andres@anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2010-07-16 19:12:33 | Re: ALTER TABLE SET STATISTICS requires AccessExclusiveLock |
| Previous Message | Pavel Stehule | 2010-07-16 19:08:39 | Re: patch (for 9.1) string functions |