[postgis-users] shp2pgsql bug?
Eric Lam
elam at lisasoft.com
Thu Jun 15 22:53:18 PDT 2006
Hello list,
I am back porting geometries I have loaded in postgresql8.x with postgis
1.x to a postgresql 7.4.x with postgis 0.8.x
I am doing a:
pgsql2shp -f tmp.shp -g the_geom data MLSTable
shp2pgsql -s 4283 -c -g the_geom -w tmp.shp MLSTable > table.sql
All geometries are multilinestrings. However up until recently, I have
only ever had 1 linestring in the multilinestring.
For geometries with more than 1 linestring in the multilinestring there
is a comma at the start of every extra linestring except the first.
eg MULTILINESTRING( (12 34, 23 34, 14 51),(,25 43,34 23,34 54),(,76
45,34 23))
Is this a known problem? Is there something I am missing?
At the moment I have piped the file through sed to remove the extra
comma before loading into the older database.
This is loading fine, however ....
regards
Eric Lam
More information about the postgis-users
mailing list