Re: Tab completion for ALTER MATERIALIZED VIEW ... SET ACCESS METHOD
Yugo Nagata <nagata@sraoss.co.jp>
From: Yugo NAGATA <nagata@sraoss.co.jp>
To: Michael Paquier <michael@paquier.xyz>
Cc: pgsql-hackers@postgresql.org
Date: 2022-03-22T08:53:17Z
Lists: pgsql-hackers
On Sat, 19 Mar 2022 19:31:59 +0900 Michael Paquier <michael@paquier.xyz> wrote: > 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! Thank you! -- Yugo NAGATA <nagata@sraoss.co.jp>
Commits
-
Improve handling of SET ACCESS METHOD for ALTER MATERIALIZED VIEW
- eb8399cf1f3d 15.0 landed
-
Add regression tests for ALTER MATERIALIZED VIEW with tablespaces
- ade2159bcdc1 15.0 landed
-
doc: Mention SET TABLESPACE clause for ALTER MATERIALIZED VIEW
- 49c5cd5c4e7a 10.21 landed
- b68929d6e6a3 11.16 landed
- 4d2322925187 12.11 landed
- fe14b0dd45a8 13.7 landed
- c422e8da7ec2 14.3 landed
- 9616da3ddbc1 15.0 landed
-
Add support for SET ACCESS METHOD in ALTER TABLE
- b0483263dda0 15.0 cited