Has anyone had any success directly connecting Arc 10.3 to a PostGIS/postgres database, where the geometry type is 'geometry'?
I am able to connect and view the tables, but I am unable to view them - I receive the error from ArcCatalog "the coordinate system identifier is invalid".
I have created a geodatabase out of the data using 10.3 and a provisioning file to create sde.db_tune table, but that has made no difference (FYI, geometry_storage in db_tune is "PG_GEOMETRY"). Once I created the SDE tables, I attempted to connect using 10.2 but also received the same error message.
SRID is set per QGIS table properties (QGIS views the data perfectly, by the way).
I'm using PostGres 9.3 and PostGIS 2.1. I'm using extensions "postgis" and "postgis_topology" in my public schema, so minimal table massaging appears to be necessary (like manually updating geometry_columns).