[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Error reading OID from Table. OID Column has null value
From:       Nicolas Ribot <nicolas.ribot () gmail ! com>
Date:       2012-10-31 16:18:54
Message-ID: CAGAwT=3NwTwU1196c-=_YTr78wPY9rK_DM+gjPLgBcfbCKf2xA () mail ! gmail ! com
[Download RAW message or body]

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


[prev in list] [next in list] [prev in thread] [next in thread]