laptop and a wrench

Bug

Registering a pg_geometry table with a numeric (2,0) field with ArcSDE 9.3.1, the 2-digit values of the numeric field are changed.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM049251
SubmittedOctober 1, 2009
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found9.3.1
Version FixedN/A
StatusFixed

Workaround

modifying the corresponding entry in the sde.sde_column_registry, the values will all be correct:pgis=# update sde.sde_column_registry set sde_type=4 where table_name = 'windt' and column_name = 'wid';UPDATE 1pgis=# update sde.sde_column_registry set decimal_digits=0 where table_name = 'windt' and column_name = 'wid';UPDATE 1

Steps to Reproduce

Bug ID: NIM049251

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options