<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt">Olá Alexandre!<br><br>If the gid field is serial, you can not just omit it in the Rule - Insert Into statement?<br><br>CREATE OR REPLACE RULE "_INSERT" AS ON INSERT TO "PGHP".infra_portoes DO INSTEAD<br>INSERT INTO "PGHP"."infraestruturas_pontos" ("classe","nome","geom")<br>VALUES ('portoes',NEW."nome",NEW."geom");<br><br>That way, Postgresql follows the sequence smoothly. <br><br>Or I did not realize the problem right?<br><br><br>Best regards,<br>Pedro Venâncio<br><br> <br><div><span><br></span></div><div><br></div><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 8pt;"> <div style="font-family: HelveticaNeue,
Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font face="Arial" size="2"> <b><span style="font-weight:bold;">DE:</span></b> Alexandre Neto <senhor.neto@gmail.com><br> <b><span style="font-weight: bold;">Para:</span></b> QGIS User <qgis-user@lists.osgeo.org> <br> <b><span style="font-weight: bold;">Enviadas:</span></b> Sexta-feira, 28, Fevereiro 2014 16:03:37<br> <b><span style="font-weight: bold;">Assunto:</span></b> [Qgis-user] How to set posgis default sequential value in a QGIS "editable" view?<br> </font> </div> <div class="y_msg_container"><br><div id="yiv4969414969"><div dir="ltr"><div>Hello all,</div><div><br></div><div>I have posted this question in gis.stackexchage, does anyone have a solution for it? </div><div><br></div><div>Thanks</div><div><br></div><a rel="nofollow" target="_blank" href="http://goo.gl/Bp6xZN">http://goo.gl/Bp6xZN</a><div>
<br></div><div><div style="margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(51,51,51);line-height:18px;">
<b>Introduction</b></div><div style="margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(51,51,51);line-height:18px;">
In a QGIS project I have a VIEW, that I want to became editable (I'm trying to replicate the versioning system used DB Manager with some tweeks). Therefore I created a few rules to make is so (see below). I'm able to delete and update the features without problems, but while inserting new features, I'm not being able to use postgis default value (sequence) for gid (that in this case is not a primary key) but has a NOT NULL constraint. So, if the user don't fill the gid value, qgis is not be able to commit the changes, if it does... we neve know where thing going to get wrong.</div>
<div style="margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(51,51,51);line-height:18px;">
<b>The question</b></div><div style="margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(51,51,51);line-height:18px;">
Is there a way I can prepare my view or set qgis form to read the default value?</div><div style="margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(51,51,51);line-height:18px;">
<b>What I got</b></div><div style="margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(51,51,51);line-height:18px;">
<b></b></div><pre class="yiv4969414969" 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,;background-color:rgb(238,238,238);color:rgb(57,51,24);word-wrap:normal;line-height:18px;"><code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas, Menlo, Monaco,;color:rgb(34,34,34);white-space:inherit;"><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(134,134,134);">-- The original table</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">CREATE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">TABLE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"PGHP"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">infraestruturas
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">(</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
gid serial</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
nome character </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">varying</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">(</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(149,56,56);">40</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">),</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
classe character </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">varying</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">(</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(149,56,56);">40</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">),</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
geom geometry</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">(</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">POINT</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(149,56,56);">3763</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">),</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"id_hist"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> serial </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">primary</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">key</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"time_start"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> timestamp</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"time_end"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> timestamp</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"user_update"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> character </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">varying</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">(</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(149,56,56);">40</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">)</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">);</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(134,134,134);">-- Creating the view</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">CREATE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">OR</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> REPLACE </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">VIEW</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"PGHP"</span><span class="yiv4969414969"
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">infra_portoes </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">AS</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">SELECT</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"gid"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"nome"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"geom"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">::</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">Geometry</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">(</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">POINT</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969"
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(149,56,56);">3763</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">),</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"time_start"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"user_update"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">FROM</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"PGHP"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"infraestruturas_pontos"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">WHERE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"classe"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">=</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">'portoes'</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">AND</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"time_end"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">IS</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">NULL</span><span class="yiv4969414969"
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">;</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(134,134,134);">-- Make the view editable</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">CREATE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">OR</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> REPLACE </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">RULE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"_DELETE"</span><span class="yiv4969414969"
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">AS</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">ON</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">DELETE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">TO</span><span class="yiv4969414969"
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"PGHP"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">infra_portoes DO INSTEAD
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">DELETE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">FROM</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"PGHP"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"infraestruturas_pontos"</span><span class="yiv4969414969"
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">WHERE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> gid </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">=</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> old</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">gid</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">;</span><span
class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">CREATE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">OR</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> REPLACE </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">RULE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"_INSERT"</span><span class="yiv4969414969"
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">AS</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">ON</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">INSERT</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">TO</span><span class="yiv4969414969"
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"PGHP"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">infra_portoes DO INSTEAD
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">INSERT</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">INTO</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"PGHP"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"infraestruturas_pontos"</span><span class="yiv4969414969"
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">(</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"gid"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"classe"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"nome"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span
class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"geom"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">)</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">VALUES</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">(</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">NEW</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"gid"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969"
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">'portoes'</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">NEW</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"nome"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">NEW</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span
class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"geom"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">);</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">CREATE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">OR</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> REPLACE </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">RULE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"_UPDATE"</span><span class="yiv4969414969"
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">AS</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">ON</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">UPDATE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">TO</span><span class="yiv4969414969"
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"PGHP"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">infra_portoes DO INSTEAD
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">UPDATE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"PGHP"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"infraestruturas"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">SET</span><span class="yiv4969414969"
style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"gid"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">=</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> NEW</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"gid"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"classe"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">=</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">'portoes'</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"nome"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">=</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> NEW</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"nome"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">,</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"geom"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">=</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> NEW</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon;">"geom"</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">
</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11);">WHERE</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> gid </span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">=</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"> NEW</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">.</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;">gid</span><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128);">;</span></code></pre>
<pre class="yiv4969414969" 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,;background-color:rgb(238,238,238);color:rgb(57,51,24);word-wrap:normal;line-height:18px;"><code style="margin:0px;padding:0px;border:0px;vertical-align:baseline;font-family:Consolas, Menlo, Monaco,;color:rgb(34,34,34);white-space:inherit;"><span class="yiv4969414969" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black;"><br>
</span></code></pre></div></div></div><br>_______________________________________________<br>Qgis-user mailing list<br><a ymailto="mailto:Qgis-user@lists.osgeo.org" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br><br></div> </div> </div> </blockquote><div></div> </div></body></html>