From: | "Robert Koch" <gms_xy(at)gmx(dot)de> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Extended capabilities for managing MATERIALIZED VIEWs |
Date: | 2014-07-01 08:32:47 |
Message-ID: | trinity-e2ab2915-74f6-4e7c-9aef-9af009c56032-1404203567255@3capp-gmx-bs57 |
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>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></body></html>
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/html | 1.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Koch | 2014-07-02 08:07:26 | Re: Extended capabilities for managing MATERIALIZED VIEWs |
Previous Message | Michael Paquier | 2014-06-30 11:34:37 | Re: [ADMIN] [pgadmin-support] Best backup strategy for production systems |