| From: | Dagfinn Ilmari Mannsåker <ilmari(at)ilmari(dot)org> |
|---|---|
| To: | px shi <spxlyy123(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: CREATE MATERIALIZED VIEW |
| Date: | 2024-07-25 13:56:07 |
| Message-ID: | 87cyn1eft4.fsf@wibble.ilmari.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
px shi <spxlyy123(at)gmail(dot)com> writes:
> Hi, I see that materialized view cannot be unlogged now, but when I use
> psql and type CREATE UNLOGGED, pressing the Tab key for auto-completion
> suggests `TABLE` and MATERIALIZED VIEW.
> Shouldn't `MATERIALIZED VIEW ` be suggested?
That's my fault, I added it in commit c951e9042dd1, presumably because
the grammar allows it, but it turns transformCreateTableAsStmt() rejects
it.
Attached is a patch to fix it, which sholud be backpatched to v17.
- ilmari
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Don-t-tab-complete-MATERIALIZED-VIEW-after-CREATE-UN.patch | text/x-diff | 1.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alena Rybakina | 2024-07-25 14:04:44 | Re: POC, WIP: OR-clause support for indexes |
| Previous Message | wenhui qiu | 2024-07-25 13:54:08 | Re: Add 64-bit XIDs into PostgreSQL 15 |