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