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.

Zuletzt veröffentlicht: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug-ID-Nummer NIM074415
EingereichtOctober 21, 2011
Zuletzt geändertJune 5, 2024
Gilt fürArcSDE/Enterprise Geodatabase
Gefunden in Version10.0
StatusWill Not Be Addressed

Zusätzliche Informationen

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.

Schritte zur Reproduzierung

Bug-ID: NIM074415

Software:

  • ArcSDE/Enterprise Geodatabase

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln