[postgis-users] Error reading OID from Table. OID Column has null value

[Nicolas Ribot]

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 <MarkVolz at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users