<div style="font-family: Verdana;font-size: 12.0px;"><div>Hi,</div><div> </div><div>I would like to ask for some more
capabilitiesregarding MATIERIALIZED VIEWs:</div><div> </div><div>-> In pgAdmin's tree view I would like to see an
optionto REFRESH MATERIALIZED VIEW (not only refresh the tree view).</div><div> </div><div>-> It would be useful to
havean category "Indexes" (likewise to physical tables) to manage indexing.</div><div> </div><div>Furthermore there
seemsto be a problem with updating MATERIALIZED VIEWs in pgAdmin:</div><div> </div><div>I created a materialized view
(regardless,if it's done with -> right-click -> new view, or with plain SQL):</div><div> </div><div>CREATE
MATERIALIZEDVIEW olap.test<br /> AS SELECT NULL::int as a</div><div> </div><div>When I try to update the VIEWs
definitionin pgAdmin, an error is shown in pgAdmin. PostgreSQL log says:</div><div> </div><div><div>2014-07-01 10:17:55
CESTFEHLER: Syntaxfehler bei „)“ bei Zeichen 76<br /> 2014-07-01 10:17:55 CEST ANWEISUNG: DROP MATERIALIZED VIEW
olap.test;CREATEMATERIALIZED VIEW olap.test<br /> WITH (<br /> )<br /> AS<br /> SELECT
NULL::integerAS a, NULL::varchar as b<br /> WITH DATA;</div></div><div> </div><div> </div><div>Running pgAdmin
1.18.1under Windows 8.1</div><div> </div><div>Thank you</div><div> </div><div>Robert</div><div> </div></div>
