<P>
Because in ur table the constraint is 2 dimension. U cant store point into ur table. To store point delete the constraint for two dim.<BR>
<BR>
<BR>
On Thu, 01 Nov 2007 mcompte@sigte.udg.es wrote :<BR>
>Hi,<BR>
><BR>
>I might have missed something, but I keep looking at it and can't<BR>
>understand why the following keeps throwing an 'invalid geometry' error :(<BR>
><BR>
>Here's the table:<BR>
><BR>
>------------------------<BR>
>CREATE TABLE asistentes<BR>
>(<BR>
> gid int8 NOT NULL,<BR>
> nombre varchar(150),<BR>
> longitud float8,<BR>
> latitud float8,<BR>
> the_geom geometry,<BR>
> geometria geometry,<BR>
> CONSTRAINT asistentes_pkey PRIMARY KEY (gid),<BR>
> CONSTRAINT enforce_dims_geometria CHECK (ndims(geometria) = 2),<BR>
> CONSTRAINT enforce_geotype_geometria CHECK (geometrytype(geometria) =<BR>
>'POINT'::text OR geometria IS NULL),<BR>
> CONSTRAINT enforce_srid_geometria CHECK (srid(geometria) = 4326)<BR>
>)<BR>
>WITHOUT OIDS;<BR>
>ALTER TABLE asistentes OWNER TO postgres;<BR>
>------------------------<BR>
><BR>
>The table is already populated and then I try updating one of the<BR>
>geometries with:<BR>
><BR>
>------------------------<BR>
>UPDATE asistentes SET geometria=GeometryFromText('POINT(1,1)', 4326) WHERE<BR>
>gid=3;<BR>
>------------------------<BR>
><BR>
>And I get the following Explain comment?<BR>
><BR>
>------------------------<BR>
>La consulta insertó una fila con OID 0.<BR>
><BR>
>ERROR: parse error - invalid geometry<BR>
>------------------------<BR>
><BR>
>The spanish line says something like 'the query added one row with OID 0'.<BR>
>If anyone could shed some light on this I'd very much appreciate it :)<BR>
><BR>
>Marc<BR>
><BR>
>_______________________________________________<BR>
>postgis-users mailing list<BR>
>postgis-users@postgis.refractions.net<BR>
>http://postgis.refractions.net/mailman/listinfo/postgis-users<BR>
</P>
<br><br>