topic Re: Why can't I view postgresql materialized views in ArcGIS desktop? in Geodatabase Questions

Why can't I view postgresql materialized views in ArcGIS desktop?

soniadickerson1 — Tue, 07 Jun 2016 18:58:33 GMT

I'm using postgres 9.3. and ArcGIS 10.3 desktop. Views with the same granted privileges show up but materialized views do not. Anyone else run into this? Thanks greatly, Sonia

Re: Why can't I view postgresql materialized views in ArcGIS desktop?

ChristianWells — Tue, 07 Jun 2016 23:08:08 GMT

Hi Sonia,

I can see this behavior in 10.3.1 as well, however, it looks like the behavior is fixed in 10.4. There are a lot of fixes made at this release (10.4) for querying the available objects and general performance.

Are you able to test or work with 10.4?

Re: Why can't I view postgresql materialized views in ArcGIS desktop?

soniadickerson1 — Thu, 09 Jun 2016 13:52:08 GMT

I don't have access to 10.4 right at this time, but I'm going to want to deploy an ArcGIS Server 10.3.1map service with these materialized views. So even if I had 10.4 desktop, would it even work with ArcGIS Server 10.3.1?

Re: Why can't I view postgresql materialized views in ArcGIS desktop?

ChristianWells — Thu, 09 Jun 2016 18:35:26 GMT

I haven't tested publishing to 10.3.1 Server, but I will look to test there.

Re: Why can't I view postgresql materialized views in ArcGIS desktop?

Anonymous User — Thu, 09 Jun 2016 18:53:09 GMT

Not with PostGREsql but this is the same with Oracle I believe. Are you trying to use query layers to access the Materialized View with spatial data? Without spatial data? With Oracle, to oversimplify, Materialized views don't support geometry.

Re: Why can't I view postgresql materialized views in ArcGIS desktop?

MichaelVolz — Fri, 15 Jun 2018 02:48:48 GMT

Have materialized views been modified to support geometry in ArcMap 10.5.x and 10.6?

Re: Why can't I view postgresql materialized views in ArcGIS desktop?

soniadickerson1 — Fri, 15 Jun 2018 12:55:37 GMT

Postgres materialized views work in ArcMap 10.5. Not sure about 10.6. The geometry column needs to be named shape and you need a unique identifier column in order for all of the rows to show up.