| From: | "Robert Koch" <gms_xy(at)gmx(dot)de> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: Extended capabilities for managing MATERIALIZED VIEWs |
| Date: | 2014-07-02 08:07:26 |
| Message-ID: | trinity-e2caa76c-6fe5-4ae5-a4ed-399b3a41acd6-1404288446687@3capp-gmx-bs07 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>
<div>Two more ideas regarding mat. views:</div>
<div> </div>
<div>
<div>Capability to count and show estimated/counted number of rows of a MATERIALIZED VIEW (likewise to physical tables).</div>
</div>
<div>Furthermore it would be useful to be able to "convert" a VIEW from materialized into 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:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Gesendet:</b> Dienstag, 01. Juli 2014 um 10:32 Uhr<br/>
<b>Von:</b> "Robert Koch" <gms_xy(at)gmx(dot)de><br/>
<b>An:</b> pgadmin-support(at)postgresql(dot)org<br/>
<b>Betreff:</b> [pgadmin-support] Extended capabilities for managing MATERIALIZED VIEWs</div>
<div name="quoted-content">
<div style="font-family: Verdana;font-size: 12.0px;">
<div>Hi,</div>
<div> </div>
<div>I would like to ask for some more capabilities regarding MATIERIALIZED VIEWs:</div>
<div> </div>
<div>-> In pgAdmin's tree view I would like to see an option to REFRESH MATERIALIZED VIEW (not only refresh the tree view).</div>
<div> </div>
<div>-> It would be useful to have an category "Indexes" (likewise to physical tables) to manage indexing.</div>
<div> </div>
<div>Furthermore there seems to 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 MATERIALIZED VIEW olap.test<br/>
AS SELECT NULL::int as a</div>
<div> </div>
<div>When I try to update the VIEWs definition in pgAdmin, an error is shown in pgAdmin. PostgreSQL log says:</div>
<div> </div>
<div>
<div>2014-07-01 10:17:55 CEST FEHLER: Syntaxfehler bei „)“ bei Zeichen 76<br/>
2014-07-01 10: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>Running pgAdmin 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></body></html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 2.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Barter | 2014-07-02 08:12:26 | External Editor Support |
| Previous Message | Robert Koch | 2014-07-01 08:32:47 | Extended capabilities for managing MATERIALIZED VIEWs |