Hi Mark, Just quickly tested ArcGIS 10.1 with Postgis and query layers:
The table for the test comes from a shapefile, loaded into postgis (WGS84). I can define a query layer from it and display it in ArcGIS (ArcMap ArcInfo). The error you mentioned rise when trying to export this layer to a File GDB. I then recreate the postgis table, forcing OIDS to be added to the table (with oids clause) and the export went fine. So I understand that Query layers need to work on tables defined with OIDS (which is not the default since several releases of PG) HTH Nicolas On 30 October 2012 14:38, Mark Volz <markv...@co.lyon.mn.us> wrote: > Hello, > > > I am still trying to figure out query layers and ArcGIS, I am getting an > error when I try to open up a table: "Error reading OID from Table.... OID > Column has null value." I noticed that when the table opens (blank) that > there is an additional column called ESRI_OID. How can I add the missing > column? > > Thanks > > > > > Mark Volz > GIS Specialist > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
