To Suggest a "DROP INCREMENTAL MATERIALIZED VIEW" in psql, but the syntax error when you run.

From: nuko yokohama <nuko(dot)yokohama(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: To Suggest a "DROP INCREMENTAL MATERIALIZED VIEW" in psql, but the syntax error when you run.
Date: 2019-11-28 04:00:05
Message-ID: CAF3Gu1ZZrbMDOC91Rqxet9=wvPnSP11MOYuF0-XpcFJ8c4UYYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi.

I'm using the "Incremental Materialized View Maintenance" patch and have
reported the following issues.
(https://commitfest.postgresql.org/25/2138/)

To Suggest a "DROP INCREMENTAL MATERIALIZED VIEW" in psql, but the syntax
error when you run.
("DROP MATERIALIZED VIEW" command can drop Incremental Materialozed view
normally.)

ramendb=# CREATE INCREMENTAL MATERIALIZED VIEW pref_count AS SELECT pref,
COUNT(pref) FROM shops GROUP BY pref;
SELECT 48
ramendb=# \d pref_count
Materialized view "public.pref_count"
Column | Type | Collation | Nullable | Default
---------------+--------+-----------+----------+---------
pref | text | | |
count | bigint | | |
__ivm_count__ | bigint | | |

ramendb=# DROP IN
INCREMENTAL MATERIALIZED VIEW INDEX
ramendb=# DROP INCREMENTAL MATERIALIZED VIEW pref_count;
2019-11-27 11:51:03.916 UTC [9759] ERROR: syntax error at or near
"INCREMENTAL" at character 6
2019-11-27 11:51:03.916 UTC [9759] STATEMENT: DROP INCREMENTAL
MATERIALIZED VIEW pref_count;
ERROR: syntax error at or near "INCREMENTAL"
LINE 1: DROP INCREMENTAL MATERIALIZED VIEW pref_count;
^
ramendb=# DROP MATERIALIZED VIEW pref_count ;
DROP MATERIALIZED VIEW
ramendb=#

Regard.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2019-11-28 04:01:10 Re: psql - improve test coverage from 41% to 88%
Previous Message Michael Paquier 2019-11-28 03:57:10 Re: amcheck verification for GiST