Opened 10 years ago

Closed 10 years ago

Last modified 10 years ago

#5290 closed defect (fixed)

ogr2ogr + PostgreSQL mistranslates numeric fields

Reported by: pseudonym Owned by: warmerdam
Priority: normal Milestone: 1.10.2
Component: OGR_SF Version: 1.10.1
Severity: normal Keywords: pg
Cc:

Description

Unqualified numeric fields in PostgreSQL seem to be mistranslated.

There are three files attached. Run in.sql to generate the test database, and run.sh to invoke ogr2ogr. The result that I get is shown in out.sql.

Note that not only do the numeric fields have artificial precision added, they are suspiciously sequential.

Attachments (3)

in.sql​ (273 bytes ) - added by pseudonym 10 years ago.
in.sql
run.sh​ (53 bytes ) - added by pseudonym 10 years ago.
run.sh
out.sql​ (1.0 KB ) - added by pseudonym 10 years ago.
out.sql

Download all attachments as: .zip

Change History (5)

by pseudonym, 10 years ago

Attachment: in.sql​ added

in.sql

by pseudonym, 10 years ago

Attachment: run.sh​ added

run.sh

by pseudonym, 10 years ago

Attachment: out.sql​ added

out.sql

comment:1 by Even Rouault, 10 years ago

Component: Utilities → OGR_SF
Keywords: pg added
Milestone: → 1.10.2
Resolution: → fixed
Status: new → closed

Was already fixed in trunk in r26184

branches/1.10 r26600 "PG: fix wrong mapping of Numeric format into OGR field definition (#5290)"

comment:2 by pseudonym, 10 years ago

Thanks! I await the next release with bated breath.

Note: See TracTickets for help on using tickets.