Extended capabilities for managing MATERIALIZED VIEWs
От | Robert Koch |
---|---|
Тема | Extended capabilities for managing MATERIALIZED VIEWs |
Дата | |
Msg-id | trinity-e2ab2915-74f6-4e7c-9aef-9af009c56032-1404203567255@3capp-gmx-bs57 обсуждение исходный текст |
Ответы |
Re: Extended capabilities for managing
MATERIALIZED VIEWs
|
Список | 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 по дате отправления: