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

List:       postgis-users
Subject:    Re: [postgis-users] AddGeometryColumn type GEOMETRY raises error
From:       David Blasby <dblasby () refractions ! net>
Date:       2003-03-20 17:04:54
Message-ID: 3E79F4B6.9090601 () refractions ! net
[Download RAW message or body]

Vincent Schut wrote:

>If I try to add a geometry column with type is GEOMETRY I get this error:
>
>psql:../scripts/create_main_tables.sql:15: ERROR:  Invalid type name - valid 
>ones are: 
>GEOMETRY,GEOMETRYCOLLECTION,POINT,MULTIPOINT,POLYGON,MULTIPOLYGON,LINESTRING, 
>or MULTILINESTRING
>
>Though I really specified 'GEOMTERY' as type:
>SELECT AddGeometryColumn('indo_mof_gis', 'hph', 'hph_geom', -1, 'GEOMETRY', 2 
>);
>
>Did I overlook something?
>With any other of the possible types everything works OK.
>  
>
This is fixed in the CVS version (we noticed it last week).  Either use 
the CVS version or use 'geometry' (lowercase).

dave



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