Capability to count and show estimated/counted number of rows of a MATERIALIZED VIEW (likewise to physical tables).
Furthermore it would be useful to be able to "convert" a VIEW from materialized into not-materialized and vice versa. This could bo done in editing properties -> materialization checkbox. It's clear, that a MATERIALIZED VIEW is very different from a regular VIEW, so converting means DROP and CREATE.
Gesendet: Dienstag, 01. Juli 2014 um 10:32 Uhr Von: "Robert Koch" <gms_xy@gmx.de> An: pgadmin-support@postgresql.org Betreff: [pgadmin-support] Extended capabilities for managing MATERIALIZED VIEWs
Hi,
I would like to ask for some more capabilities regarding MATIERIALIZED VIEWs:
-> In pgAdmin's tree view I would like to see an option to REFRESH MATERIALIZED VIEW (not only refresh the tree view).
-> It would be useful to have an category "Indexes" (likewise to physical tables) to manage indexing.
Furthermore there seems to be a problem with updating MATERIALIZED VIEWs in pgAdmin:
I created a materialized view (regardless, if it's done with -> right-click -> new view, or with plain SQL):
CREATE MATERIALIZED VIEW olap.test AS SELECT NULL::int as a
When I try to update the VIEWs definition in pgAdmin, an error is shown in pgAdmin. PostgreSQL log says:
2014-07-01 10:17:55 CEST FEHLER: Syntaxfehler bei „)“ bei Zeichen 76 2014-07-01 10:17:55 CEST ANWEISUNG: DROP MATERIALIZED VIEW olap.test;CREATE MATERIALIZED VIEW olap.test WITH ( ) AS SELECT NULL::integer AS a, NULL::varchar as b WITH DATA;
