Tab completion for ALTER MATERIALIZED VIEW ... SET ACCESS METHOD

Yugo Nagata <nagata@sraoss.co.jp>

From: Yugo NAGATA <nagata@sraoss.co.jp>

To: pgsql-hackers@postgresql.org

Date: 2022-03-16T04:33:37Z

Lists: pgsql-hackers

Attachments

tab_complete_alter_matview.patch (text/x-diff) patch

Hello hackers,

SET ACCESS METHOD is supported in ALTER TABLE since the commit
b0483263dd. Since that time,  this also has be allowed SET ACCESS
METHOD in ALTER MATERIALIZED VIEW. Although it is not documented,
this works.

I cannot found any reasons to prohibit SET ACCESS METHOD in ALTER
MATERIALIZED VIEW, so I think it is better to support this in psql
tab-completion and be documented.

I attached a patch to fix the tab-completion and the documentation
about this syntax. Also, I added description about SET TABLESPACE
syntax that would have been overlooked.

Regards,
Yugo Nagata


-- 
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