Subscribe to this thread
Home - General / All posts - PostgreSQL Materialized Views
joebocop
369 post(s)
#09-Mar-19 22:03

I have a PostgreSQL 10.6 database which contains a materialized view:

create materialized view field_data.ss_mat AS select s_id, _geometry FROM ss;

PostgreSQL mat view support was added back in 9.0.166.3.

Release 9.0.168.0 correctly opens the Drawing component located within the PostgreSQL data source.

Releases 9.0.168.10 and .9 fail to open that same component with the error "Invalid Data Item".

The Manifold datasource SQL9 DDL are identical; I copied and pasted between the running .0 and .10 applications.

The mat view does not return any "date time" data types (change in Release 9.0.168.6), only the text and geometry fields "s_id" and "_geometry". I don't know if many other folks are using pg mat views, so I thought I'd flag the issue.

Thanks!

Attachments:
mat_view.png

Dimitri


5,359 post(s)
#10-Mar-19 07:29

Send in a bug report.

adamw


8,447 post(s)
#11-Mar-19 08:40

Yes, please send in a bug report, like Dimitri says.

Ideally, we'd need example data to reproduce the issue - you could try copy / pasting the table backing the view (ss) into a MAP file then copy / pasting it back to PostgreSQL, creating a similar materialized view on the new table and seeing if it will run into the same issue - if it does, that's great, because we'd be able to reproduce it on our end the same way.

Manifold User Community Use Agreement Copyright (C) 2007-2017 Manifold Software Limited. All rights reserved.