Ticket #1344 (closed defect: fixed)

Opened 18 months ago

Last modified 17 months ago

ST_MakeLine fails for export with pgsql2shp

Reported by: bporfidia Owned by: strk
Priority: medium Milestone: PostGIS 1.5.4
Component: postgis Version: 1.5.X
Keywords: st_makeline Cc:

Description

making linestring with st_makeline from a table of points, fails the export with pgsql2shp and connection to qgis

postgis ver.

SELECT postgis_full_version() "POSTGIS="1.5.1" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21 August 2008" LIBXML="2.7.6" USE_STATS"

export error C:\Programmi\PostgreSQL\8.4\bin>pgsql2shp.exe -h xxx.xxx.xxx.xxx -u postgres -P postgres -r -b -f linee.shp geofisica public.nav

Initializing... Done (postgis major version: 1). Output shape: PolyLine? Dumping: XRecordFetch: ERROR: geometry requires more points

Attachments

dump_nav.csv Download (34.8 KB) - added by bporfidia 18 months ago.
table_made_by_makeline dump

Change History

Changed 18 months ago by bporfidia

table_made_by_makeline dump

Changed 17 months ago by strk

  • owner changed from pramsey to strk
  • status changed from new to assigned
  • milestone changed from PostGIS 2.0.0 to PostGIS 1.5.4

Culprit is ST_asEWKB() which complains in 1.5 but doesn't complain in 2.0. Normal dumps (done with pg_dump) won't complain as they'd be using canonical output.

I think we could change 1.5 to also not complain. Doing so would allow another 2.0 upgrade path (stepping by shapefiles)

Changed 17 months ago by strk

It strikes me that

 result = serialized_lwgeom_from_ewkt(&lwg_parser_result, str, PARSER_CHECK_ALL);

does _not_ fail when passed the single-point linestring HEXWKB, is that expected ?

Changed 17 months ago by strk

  • status changed from assigned to closed
  • resolution set to fixed

Fixed by r8443

Note: See TracTickets for help on using tickets.