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