Re: Tab completion for ALTER MATERIALIZED VIEW ... SET ACCESS METHOD - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Tab completion for ALTER MATERIALIZED VIEW ... SET ACCESS METHOD
Date
Msg-id YjWxH/nqqq6ofIWa@paquier.xyz
Whole thread Raw
In response to Re: Tab completion for ALTER MATERIALIZED VIEW ... SET ACCESS METHOD  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Tab completion for ALTER MATERIALIZED VIEW ... SET ACCESS METHOD
List pgsql-hackers
On Fri, Mar 18, 2022 at 03:13:05PM +0900, Michael Paquier wrote:
> Thanks.  This looks rather sane to me.  I'll split things into 3
> commits in total, as of the psql completion, SET TABLESPACE and SET
> ACCESS METHOD.  The first and third patches are only for HEAD, while
> the documentation hole with SET TABLESPACE should go down to v10.
> Backpatching the tests of ALTER MATERIALIZED VIEW ALL IN TABLESPACE
> would not hurt, either, as there is zero coverage for that now.

I have applied the set, after splitting things mostly as mentioned
upthread:
- The doc change for SET TABLESPACE on ALTER MATVIEW has been
backpatched.
- The regression tests for SET TABLESPACE have been applied on HEAD,
as these are independent of the rest, good on their own.
- All the remaining parts for SET ACCESS METHOD (psql tab completion,
tests and docs) have been merged together on HEAD.  I could not
understand why the completion done after SET ACCESS METHOD was not
grouped with the other parts for ALTER MATVIEW, so I have moved the
new entry there, and I have added a test checking after an error for
multiple subcommands, while on it.

Thanks, Nagata-san!
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Pavel Borisov
Date:
Subject: Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)
Next
From: Alvaro Herrera
Date:
Subject: Re: support for MERGE