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

[Nicolas Ribot]

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 <nicolas.ribot at gmail.com> 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 <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