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 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 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