<div dir="ltr">Can you display the query that is executed by the trigger function ?<br><div>(RAISE NOTICE command is handy for that.)</div><div><br></div><div>Are the gid you are joining on valid in both tables ?</div><div>
<br><div style>Nicolas</div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 28 January 2013 17:24, Marcello Benigno <span dir="ltr"><<a href="mailto:benigno.marcello@gmail.com" target="_blank">benigno.marcello@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto"><div>Hi Nicolas,</div><div><br></div><div><span style="background-color:rgba(255,255,255,0)">No error message, just the field is not filled.</span></div>
<div><br></div><div><br><span>Marcello Benigno</span></div><div><br>Em 28/01/2013, às 12:48, Nicolas Ribot <<a href="mailto:nicolas.ribot@gmail.com" target="_blank">nicolas.ribot@gmail.com</a>> escreveu:<br><br></div>
<div><div class="h5"><blockquote type="cite"><div><div dir="ltr">Hi,<div><br></div><div>Any error message ?</div><div><br></div><div>Nicolas</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 28 January 2013 16:11, Marcello Benigno <span dir="ltr"><<a href="mailto:benigno.marcello@gmail.com" target="_blank">benigno.marcello@gmail.com</a>></span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello All,<div><br>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".</div>


<div><br></div><div><pre style="margin-top:0px;margin-bottom:10px;padding:5px;border:0px;font-size:12px;vertical-align:baseline;overflow:auto;width:auto;max-height:600px;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;background-color:rgb(238,238,238);color:rgb(57,51,24);line-height:18px">
<code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas,Menlo,Monaco,'Lucida Console','Liberation Mono','DejaVu Sans Mono','Bitstream Vera Sans Mono','Courier New',monospace,serif;color:rgb(34,34,34)"><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">CREATE</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">OR</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> REPLACE </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">FUNCTION</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> topology_fields</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">()</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> 
RETURNS </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"trigger"</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">AS</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">$$</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">BEGIN</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
NEW</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">municipios_abastecidos</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">:=(</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
                      </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">SELECT</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> string_agg</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">(</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">municipios</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">nome</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">', '</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">)</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
                      </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">FROM</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> municipios</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> adutoras
                      </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">WHERE</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> ST_Intersects</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">(</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">adutoras</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">geom</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> municipios</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">geom</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">)</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
                      </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">AND</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> adutoras</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">gid </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">=</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> NEW</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">gid
                    </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">);</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">RETURN</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> NEW</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">;</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">END</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">;</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> 
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">$$</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
LANGUAGE </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">'plpgsql'</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">;</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">


</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">CREATE</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">TRIGGER</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> fill_topology_fields
BEFORE </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">INSERT</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">OR</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">UPDATE</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">ON</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> adutoras
</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">FOR</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> EACH </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">ROW</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">EXECUTE</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">PROCEDURE</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> topology_fields</span><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">();</span></code></pre>


<div><br></div><div><div>Thanks in advance,<span><font color="#888888"><br><div>-- <br><b>Marcello Benigno B. de Barros Filho</b><br><font size="1">Prof. do Curso Superior de Tecnologia em Geoprocessamento - IFPB<br>
Mestre em Ciências Geodésicas e Tecnologias da Geoinformação - UFPE</font><div>
<font size="1">Doutorando em Tecnologia Ambiental e Recursos Hídricos - UFPE</font><font size="1"><br></font><font size="1"><a href="http://profmarcello.blogspot.com" target="_blank">http://profmarcello.blogspot.com</a></font><div>


<a href="http://about.me/marcello.benigno" target="_blank"><font size="1">http://about.me/marcello.benigno</font></a></div></div>
</div></font></span></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>postgis-users mailing list</span><br><span><a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a></span><br>
<span><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></span><br></div></blockquote></div></div></div><br>_______________________________________________<br>

postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>