The PostgreSQL OLE DB Provider within ArcCatalog's Add OLE DB Connection does not properly translate the objectid of a Postgres database table to the Data Type of OBJECTID.
上次发布: August 25, 2014ArcSDE/Enterprise Geodatabase
漏洞 ID 编号
NIM074415
已提交
October 21, 2011
上次修改时间
June 5, 2024
适用范围
ArcSDE/Enterprise Geodatabase
找到的版本
10.0
状态
Will Not Be Addressed
开发团队已考虑过该问题或请求,并决定不会解决该问题。 问题的“其他信息”部分可能包含进一步说明。
附加信息
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.
解决办法
1. In ArcMap select file > Add Data > Add Query Layer.2. When the Make Query Layer dialog box appears, select Connections > New > (Fill in Parameters) > Test Connection > OK > OK. 3. Select the table name you wish to use under "List of Tables".4. Where it reads "Name:", type a name for the layer to be created.5. Under Query type: select * from TableName. Note: replace TableName with the actual name of the table 6. Select Finish. The table should appear within the ArcMap table of contents.7. From within the ArcMap table of contents right-click the table and select Properties > Fields tab and select objectid. You will notice on the right side of the dialog box the Data Type will read ObjectID.