Newly created tables, & views in Postgres DB not visible in ArcGIS Pro DB-connection?

WilcoL — Tue, 09 Jan 2024 07:32:10 GMT

PostgreSQL 15.1

ArcGIS Pro 3.1.0

Hi all,

I'm running into serious problems accessing data from a PostgreSQL 15.1 database. I simply want to access tables and views created in this database in AG Pro. When I create a database connection from my Catalog-window (as the schema owner), I can see mutliple tables and views, but newly created tables or views are not displayed.

I've made sure the geometry is stored in a SHAPE-column and an integer OBJECTID is present. I used to work a lot with ESRI-products (from 1999 up to 2020) and are experienced with QGIS as well.

Needless to say, the tables & views work perfectly in QGIS.

I really have no clue why I can not see any of the new items in my database-connection in AG Pro...

Any assistance is appreciated, thanks!

Re: Newly created tables, & views in Postgres DB not visible in ArcGIS Pro DB-connection?

George_Thompson — Tue, 09 Jan 2024 11:37:10 GMT

Based on the information provided, that configuration may not be supported. This "highest" PostgreSQL version supported for Pro 3.1.x is 14.x: https://enterprise.arcgis.com/en/system-requirements/11.1/windows/database-requirements-postgresql.htm

Now some things "could" work with PostgreSQL 15.x but you may see unexpected behavior.

If you need to use PG 15.1, then I would recommend upgrading ArcGIS Pro to version 3.2.x; https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-postgresql.htm.

topic Newly created tables, & views in Postgres DB not visible in ArcGIS Pro DB-connection? in Data Management Questions

Newly created tables, & views in Postgres DB not visible in ArcGIS Pro DB-connection?

Re: Newly created tables, & views in Postgres DB not visible in ArcGIS Pro DB-connection?