laptop and a wrench

Bogue

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.

Dernière publication: August 25, 2014 ArcSDE/Enterprise Geodatabase
Numéro d’ID de bogue NIM074415
EnvoiOctober 21, 2011
Dernière modificationJune 5, 2024
S’applique àArcSDE/Enterprise Geodatabase
Version trouvée10.0
StatutWill Not Be Addressed

Informations supplémentaires

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.

Solution de contournement

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.

Étapes pour reproduire

ID de bogue: NIM074415

Logiciel:

  • ArcSDE/Enterprise Geodatabase

Recevoir une notification lorsque le statut d’un bogue change

Télécharger l’application Esri Support

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique

Télécharger l’application Esri Support

Accéder aux options de téléchargement