[postgis-users] pgsql2shp error

[Christian Jauvin]

Hi,

I am trying to use pgsql2shp on Ubuntu 10.04 64-bit:

$ dpkg -l | grep postgis
ii  postgis                              1.5.2-2~lucid1
ii  postgresql-8.4-postgis               1.5.2-2~lucid1

The problem:

$ pgsql2shp geo_db "select * from sdr_2001"
Preparing table for user query... Done.
Initializing... Geometry type unknown (have you enabled postgis?)
WARNING: Cannot determine spatial reference (empty table or unknown
spatial ref). No prj file will be generated.
Done (postgis major version: 1).
Output shape: Polygon
Dumping: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX [4700 rows].

"geo_db" is a perfectly valid PostGIS database:

geo_db=# select postgis_full_version();
                                  postgis_full_version
----------------------------------------------------------------------------------------
 POSTGIS="1.4.0" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23
September 2009" USE_STATS

Any idea about what I'm doing wrong?

Thanks,

Christian