Extended capabilities for managing MATERIALIZED VIEWs - Mailing list pgadmin-support

From Robert Koch
Subject Extended capabilities for managing MATERIALIZED VIEWs
Date
Msg-id trinity-e2ab2915-74f6-4e7c-9aef-9af009c56032-1404203567255@3capp-gmx-bs57
Whole thread Raw
Responses Re: Extended capabilities for managing MATERIALIZED VIEWs
List pgadmin-support
<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> 

pgadmin-support by date:

Previous
From: "Emanuele Sottocorno"
Date:
Subject: Character[] field value are truncated
Next
From: "Robert Koch"
Date:
Subject: Re: Extended capabilities for managing MATERIALIZED VIEWs