<div style="font-family: Verdana;font-size: 12.0px;"><div><div>Two more ideas regarding mat.
views:</div><div> </div><div><div>Capabilityto count and show estimated/counted number of rows of a MATERIALIZED VIEW
(likewiseto physical tables).</div></div><div>Furthermore it would be useful to be able to "convert" a VIEW from
materializedinto 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.</div><div> </div><div> <div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px;
border-left:2pxsolid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break:
after-white-space;"><divstyle="margin:0 0 10px 0;"><b>Gesendet:</b> Dienstag, 01. Juli 2014 um 10:32 Uhr<br
/><b>Von:</b> "RobertKoch" <gms_xy@gmx.de><br /><b>An:</b> pgadmin-support@postgresql.org<br
/><b>Betreff:</b> [pgadmin-support]Extended capabilities for managing MATERIALIZED VIEWs</div><div
name="quoted-content"><divstyle="font-family: Verdana;font-size: 12.0px;"><div>Hi,</div><div> </div><div>I would like
toask for some more capabilities regarding MATIERIALIZED VIEWs:</div><div> </div><div>-> In pgAdmin's tree view I
wouldlike to see an option to REFRESH MATERIALIZED VIEW (not only refresh the tree view).</div><div> </div><div>->
Itwould be useful to have an category "Indexes" (likewise to physical tables) to manage
indexing.</div><div> </div><div>Furthermorethere seems to be a problem with updating MATERIALIZED VIEWs in
pgAdmin:</div><div> </div><div>Icreated a materialized view (regardless, if it's done with -> right-click -> new
view,or with plain SQL):</div><div> </div><div>CREATE MATERIALIZED VIEW olap.test<br /> AS SELECT NULL::int as
a</div><div> </div><div>WhenI try to update the VIEWs definition in pgAdmin, an error is shown in pgAdmin. PostgreSQL
logsays:</div><div> </div><div><div>2014-07-01 10:17:55 CEST FEHLER: Syntaxfehler bei „)“ bei Zeichen 76<br />
2014-07-0110:17:55 CEST ANWEISUNG: DROP MATERIALIZED VIEW olap.test;CREATE MATERIALIZED VIEW olap.test<br />
WITH(<br /> )<br /> AS<br /> SELECT NULL::integer AS a, NULL::varchar as b<br /> WITH
DATA;</div></div><div> </div><div> </div><div>RunningpgAdmin 1.18.1 under Windows 8.1</div><div> </div><div>Thank
you</div><div> </div><div>Robert</div><div> </div></div></div></div></div></div></div>
