laptop and a wrench

Bug

The Copy tool in ArcGIS Pro copies whole values in a 'Double' field as decimals in a PostgreSQL enterprise geodatabase.

Last Published: January 17, 2023 ArcGIS Pro
Bug ID Number BUG-000154805
SubmittedDecember 29, 2022
Last ModifiedJune 12, 2025
Applies toArcGIS Pro
Version found2.9.5
Operating SystemWindows OS
Operating System Version10.0 64 Bit
Version Fixed3.1, 3.04 Patch
StatusFixed

Workaround

Create an empty feature class in the PostgreSQL enterprise geodatabase with the same fields or data types. Run the Append tool to append the data successfully without decimal places appearing.

  1. Right-click the PostgreSQL enterprise geodatabase Spatial Database Engine (SDE) connection in the Catalog pane > New > Feature Class.
  2. Add a new field with the Double data type in the Create Feature Class pane.
  3. Click Finish to finish creating the new feature class.
  4. Once created, open the Geoprocessing pane and search for the Append tool. Set the parameters as below:
    1. Input Datasets: The file geodatabase feature class.
    2. Target Dataset: The enterprise geodatabase empty feature class.
    3. Field Matching Type: Use the field map to reconcile field differences.

Steps to Reproduce

Bug ID: BUG-000154805

Software:

  • ArcGIS Pro

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