[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] pgsql2shp error
From:       Christian Jauvin <cjauvin () gmail ! com>
Date:       2011-10-23 16:53:14
Message-ID: CAJSE4TqowNNkxMH3-s2bf2DqMBT4HD=WUmrFfUOe7P-=18FdsQ () mail ! gmail ! com
[Download RAW message or body]

> Are you sure that the projection you are using is in your spatial_ref_sys
> table?

Thanks, that solved it! I hadn't specified any projection with
shp2pgsql, so I updated my geometry_columns with:

select updategeometrysrid(<table>, <column>, 4326);

and it now works. The funny thing though is that there is still an
error/warning message
at the start:

Preparing table for user query... Done.
Initializing... Geometry type unknown (have you enabled postgis?)
Done (postgis major version: 1).
Output shape: PolyLine
Dumping: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
[8603 rows].

..but it doesn't seem to affect the results. Thanks again!
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]