[postgis-users] PostGIS Trigger doesn't work

[Nicolas Ribot]

Hi,

Any error message ?

Nicolas


On 28 January 2013 16:11, Marcello Benigno <benigno.marcello at gmail.com>wrote:

> Hello All,
>
> The trigger below don't works and I need that when a new pipeline
> (adutoras) is inserted or updated, the procedure check what are the
> municipalities (municipios) that intersects the pipes and put the names of
> the municipalities inside the field "municipios_abastecidos".
>
> CREATE OR REPLACE FUNCTION topology_fields()
> RETURNS "trigger" AS$$BEGIN
> NEW.municipios_abastecidos:=(
>                       SELECT string_agg(municipios.nome,', ')
>                       FROM municipios, adutoras
>                       WHERE ST_Intersects(adutoras.geom, municipios.geom)
>                       AND adutoras.gid = NEW.gid
>                     );RETURN NEW;END; $$
> LANGUAGE 'plpgsql';
>
> CREATE TRIGGER fill_topology_fields
> BEFORE INSERT OR UPDATE ON adutorasFOR EACH ROW EXECUTE PROCEDURE topology_fields();
>
>
> Thanks in advance,
> --
> *Marcello Benigno B. de Barros Filho*
> Prof. do Curso Superior de Tecnologia em Geoprocessamento - IFPB
> Mestre em Ciências Geodésicas e Tecnologias da Geoinformação - UFPE
> Doutorando em Tecnologia Ambiental e Recursos Hídricos - UFPE
> http://profmarcello.blogspot.com
> http://about.me/marcello.benigno
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130128/39dd1a44/attachment.html>