[postgis-users] [Fwd: Error using pgsql2shp]

[Luis Mota]

  Hi.

I sent this message about a week ago. In the meantime, I upgraded to 
version 0.7.3, but the result is the same. Can anyone give me a hint on 
this?

Bye and thanks, Luís

-------- Original Message --------
Subject: Error using pgsql2shp
Date: Thu, 03 Oct 2002 04:17:08 +0100
From: Luis Mota <luis.mota at iscte.pt>
To: postgis-users at postgis.refractions.net
References: <3D99BA66.EA3EBB51 at geo.unizh.ch> 
<3D9AA5F3.F3928CD9 at geo.unizh.ch> <3D9B857E.68FB203A at refractions.net> 
<200210021714.39833.andy at streetlight.com>



Hi.

I was trying to export one of my tables to a shapefile, issuing the command

pgsql2shp -f /trabalho/bd/location.shp -g geom gis_teste2 location

 but I get the following error:
ERROR: Cannot have multiple geometry types in a shapefile.

What surprises me is that this table has no multiple geometry, as you 
can see by its description, included at the end.

Am I not understanding this correctly?

Bye, Luís


                                           Table "location"
         Column          |       Type       |                        
Modifiers                       
-------------------------+------------------+---------------------------------------------------------
 slqtid                  | integer          | not null default 
nextval('"location_slqtid_seq"'::text)
 gID                     | integer          |
 x                       | double precision |
 y                       | double precision |
 z                       | double precision |
 pcsID                   | integer          |
 pcsAuthor               | text             |
 latitude                | double precision |
 longitude               | double precision |
 height                  | double precision |
 gcsID                   | integer          |
 gcsAuthor               | text             |
 publicPlaceType         | text             |
 publicPlaceName         | text             |
 buildingName            | text             |
 buildingSubdivisionType | text             |
 buildingSubdivisionName | text             |
 numberType              | text             |
 doorNumber              | text             |
 floorName               | text             |
 floorSideName           | text             |
 zipCode                 | text             |
 cityName                | text             |
 stateName               | text             |
 countryName             | text             |
 language                | text             |
 geom                    | geometry         |
 dummy                   | boolean          | default 'f'::bool
Primary key: location_pkey
Check constraints: "$1" (srid(geom) = 20790)
                   "$2" ((geometrytype(geom) = 'POINT'::text) OR 
(NULL::geometry = geom))
Rules: loc_insert
Triggers: RI_ConstraintTrigger_994633,
          RI_ConstraintTrigger_994631,
          RI_ConstraintTrigger_994621,
          RI_ConstraintTrigger_994619,
          RI_ConstraintTrigger_994609,
          RI_ConstraintTrigger_994607