[postgis-users] pgsql2shp having trouble finding geometry column

[Eric Hanson]

Hey,

I'm running into some troubles using pgsql2shp.  It seems to not be able 
to find the geometry column:

elhanson:~/public_html/oscdl/bin:544 > pgsql2shp -h localhost \
-p 5432 \
-u mapserve \
-f r2001_maj_art.shp \
newrlis \
"SELECT AsText(the_geom) AS the_geom FROM r2001_maj_art WHERE the_geom 
&& SetSRID ('BOX3D(7505411 556856, 7832855 778550)'::box3d,2913)"
Preparing table for user query... Done.
Initializing... No geometry column found.
The DBF file will be created but not the shx or shp files.
Done (postgis major version: 1).
Output shape: Null Shape
Dumping: XXXXXXXXXXXXXXXXXXXXXXXXXX [2484 rows].
elhanson:~/public_html/oscdl/bin:545 >

There's definately a geometry column called the_geom.  Any ideas?

Thanks,
Eric