[PostGIS] #2850: Preserve scale and precision when generating shape file with pgsql2shp

PostGIS trac at osgeo.org
Sun Jun 21 12:09:31 PDT 2026


#2850: Preserve scale and precision when generating shape file with pgsql2shp
------------------------------+-----------------------------
  Reporter:  hopfgartner      |      Owner:  strk
      Type:  enhancement      |     Status:  closed
  Priority:  medium           |  Milestone:  PostGIS Fund Me
 Component:  utils/pgsql2shp  |    Version:  2.1.x
Resolution:  fixed            |   Keywords:  pgsql2shp
------------------------------+-----------------------------
Changes (by Darafei Praliaskouski <me@…>):

 * resolution:   => fixed
 * status:  new => closed

Comment:

 In [changeset:"92903a731a5dc918318e57c0746ba407d84eccdc/git"
 92903a73/git]:
 {{{#!CommitTicketReference repository="git"
 revision="92903a731a5dc918318e57c0746ba407d84eccdc"
 loader: preserve numeric DBF metadata in pgsql2shp

 Decode numeric typmod precision and scale when selecting DBF field
 metadata so pgsql2shp preserves fixed numeric declarations that fit in the
 DBF field-width limit. Keep legacy 32,10 metadata for untyped numeric
 values.

 Add pgsql2shp dumper coverage for portable numeric typmods, and gate
 PostgreSQL 15+ negative-scale numeric coverage behind the configured
 PostgreSQL version.

 Closes #2850

 Closes https://github.com/postgis/postgis/pull/1020
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/2850#comment:13>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list