By the way, as the error occured when reading the table, did you check your table have a primary key ? (mine had integer one)
Nicolas On 31 October 2012 17:17, Nicolas Ribot <[email protected]> wrote: > 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 <[email protected]> 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 >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
