laptop and a wrench

Bug

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.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM074415
SubmittedOctober 21, 2011
Last ModifiedJune 5, 2024
Applies toArcSDE/Enterprise Geodatabase
Version found10.0
StatusWill Not Be Addressed

Additional Information

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.

Workaround

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.

Steps to Reproduce

Bug ID: NIM074415

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options