[postgis-users] FYI: Solution to Using PostGIS in ArcGIS.

Stefan Keller sfkeller at gmail.com
Tue Nov 6 13:03:42 PST 2012

This seems to be a problem in ArcGIS since Oct 2009 Beta 10(!) [1]
Does anyboy know if a bug ticket has been filed at Esri?

Yours, Stefan

[1] http://forums.arcgis.com/threads/1010-Beta-10-query-layer-from-postgis-oid-field-not-valid

2012/11/6 Mark Volz <MarkVolz at co.lyon.mn.us>:
> Hello,
> Recently I was struggling with getting PostGIS data in ArcGIS as a query layer.  Apparently there is a bug in ArcGIS that treats every column in a query layer as a primary key.  Here is the work around that I was given:
> Open the ArcGIS Add Query Layer window.
> Connect to your database.
> Add a query and name, usually by double clicking on the table / layer name.
> Validate the query.
> Press "show advanced options."
> The "Finish" button will change to "Next>"  Press the button.
> Press control and right click on any of the boxes under Unique Identifier Field(s).  This will unselect all the columns
> Select the actual Unique Identifier Fields - usually gid when using the PostGIS Shapefile loader.
> Press Finish
> Thanks
> Mark Volz
> GIS Specialist
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

More information about the postgis-users mailing list