Two more ideas regarding mat. views:

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;

Running pgAdmin 1.18.1 under Windows 8.1

Thank you

Robert