[postgis-users] PostGIS functions inside triggers

[Eduin Yezid Carrillo Vega]

Thanks Ralf. Both tables have primary keys and GeomFromText definition
is fine now. Still getting empty values.

Eduin Yesid Carrillo Vega
Bogotá D.C., Colombia



On Mon, Feb 16, 2009 at 1:40 PM, Ralf Suhr <gisbox at web.de> wrote:
> Mhm my fault.
>
> Change one line in the function.
>
> NEW.the_geom := ST_GeomFromText('POINT(' || new.lat || ' ' ||  new.lon ||
> ')',4326);
>
> And one line in the definition of the table two.
>
>>CREATE TABLE table2
>>(
>>       gid serial NOT NULL,
>>       table2_id character varying,
>>       the_geom geometry,
>        CONSTRAINT table2_pkey PRIMARY KEY (table2_id),
>>       CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
>>       CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) =
>>'MULTIPOLYGON'::text OR the_geom IS NULL),
>>       CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 4326)
>> )
>>WITH (OIDS=FALSE);
>
> thats all.
>
> Ralf
>