Opened 12 years ago

Closed 12 years ago

Last modified 6 months ago

#1900 closed defect (fixed)

Fix pgsql2shp for big-endian systems

Reported by: rroliver Owned by: strk
Priority: critical Milestone: PostGIS 2.0.2
Component: utils/pgsql2shp Version: 2.0.x
Keywords: pgsql2shp bigendian history Cc:

Description

pgsql2shp has been broken for all 2.0.0 versions (since r5828) on all big-endian systems.

Specifying the column name _geoX for the geometry column was neglected in the main scan query for big-endian systems, causing breakage in ShpLoaderGenerateShapeRow as this is the column name searched for to retrieve the geometry column number (geocolnum).

Symptoms of issue are empty shapefile output and the error msg

"column number -1 is out of range 0..x"

for every row in table.

Patch attached

Tested and working on Solaris Sparc (32 and 64)

Attachments (1)

postgis-2.0.1-pgsql2shp_fix_query_for_bigendian-1.patch (1.3 KB ) - added by rroliver 12 years ago.
Fixes pgsql2shp on big-endian systems

Download all attachments as: .zip

Change History (5)

by rroliver, 12 years ago

Fixes pgsql2shp on big-endian systems

comment:1 by rroliver, 12 years ago

Component: postgisloader/dumper
Owner: changed from pramsey to mcayland

comment:2 by strk, 12 years ago

Owner: changed from mcayland to strk
Status: newassigned

comment:3 by strk, 12 years ago

Keywords: history added
Resolution: fixed
Status: assignedclosed

r10033 in 2.0 branch, r10034 in trunk — thanks!

comment:4 by strk, 6 months ago

Component: utils/loader-dumperutils/pgsql2shp
Note: See TracTickets for help on using tickets.