Re: Doubt about AccessExclusiveLock in ALTER TABLE .. SET ( .. ); - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: Doubt about AccessExclusiveLock in ALTER TABLE .. SET ( .. );
Date
Msg-id CAFcNs+p6iT+Q_FJpuRgjme4VSD+j3+n4Z328jmEZ3b05dGJpRw@mail.gmail.com
Whole thread Raw
In response to Re: Doubt about AccessExclusiveLock in ALTER TABLE .. SET ( .. );  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Doubt about AccessExclusiveLock in ALTER TABLE .. SET ( .. );
List pgsql-hackers
On Thu, Jul 2, 2015 at 2:03 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
>
> The following review has been posted through the commitfest application:
> make installcheck-world:  not tested
> Implements feature:       not tested
> Spec compliant:           not tested
> Documentation:            not tested
>
> Looks functionally complete
>
> Need a test to show that ALTER TABLE works on views, as discussed on this thread. And confirmation that pg_dump is not broken by this.
>
> Message-ID:     20140321205828.GB3969106@tornado.leadboat.com
>

Added more test cases to cover ALTER TABLE on views.

I'm thinking about the isolation tests, what about add another 'alter-table' spec for isolation tests enabling and disabling 'autovacuum' options?

I did some tests using ALTER TABLE on views and also ALTER VIEW and I didn't identify any anomalies.


> Needs documentation
>

Added.

Att,


*** This work is funded by Zenvia Mobile Results (http://www.zenvia.com.br)

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello
Attachment

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: All-zero page in GIN index causes assertion failure
Next
From: Tom Lane
Date:
Subject: Re: TABLESAMPLE patch is really in pretty sad shape