<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 href="http://goo.gl/Bp6xZN">http://goo.gl/Bp6xZN</a><div>
<br></div><div><p style="margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:18px;background-color:rgba(248,248,248,0.6)">
<strong style="margin:0px;padding:0px;border:0px;vertical-align:baseline">Introduction</strong></p><p style="margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:18px;background-color:rgba(248,248,248,0.6)">
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.</p>
<p style="margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:18px;background-color:rgba(248,248,248,0.6)">
<strong style="margin:0px;padding:0px;border:0px;vertical-align:baseline">The question</strong></p><p style="margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:18px;background-color:rgba(248,248,248,0.6)">
Is there a way I can prepare my view or set qgis form to read the default value?</p><p style="margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:18px;background-color:rgba(248,248,248,0.6)">
<strong style="margin:0px;padding:0px;border:0px;vertical-align:baseline">What I got</strong></p><p style="margin:0px 0px 1em;padding:0px;border:0px;font-size:14px;vertical-align:baseline;clear:both;color:rgb(51,51,51);font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;line-height:18px;background-color:rgba(248,248,248,0.6)">
<strong style="margin:0px;padding:0px;border:0px;vertical-align:baseline"></strong></p><pre class="" 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);word-wrap:normal;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);white-space:inherit"><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(134,134,134)">-- The original table</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">CREATE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">TABLE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"PGHP"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">infraestruturas
</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">(</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
  gid serial</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
  nome character </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">varying</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">(</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(149,56,56)">40</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">),</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
  classe character </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">varying</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">(</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(149,56,56)">40</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">),</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> 
  geom geometry</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">(</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">POINT</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(149,56,56)">3763</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">),</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
  </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"id_hist"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> serial </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">primary</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">key</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
  </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"time_start"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> timestamp</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
  </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"time_end"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> timestamp</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
  </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"user_update"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> character </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">varying</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">(</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(149,56,56)">40</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">)</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">);</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">

</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(134,134,134)">-- Creating the view</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">CREATE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">OR</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> REPLACE </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">VIEW</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"PGHP"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">infra_portoes </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">AS</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
  </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">SELECT</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"gid"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"nome"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"geom"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">::</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">Geometry</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">(</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">POINT</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(149,56,56)">3763</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">),</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"time_start"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"user_update"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
  </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">FROM</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"PGHP"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"infraestruturas_pontos"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
  </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">WHERE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"classe"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">=</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">'portoes'</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">AND</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"time_end"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">IS</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">NULL</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">;</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">

</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(134,134,134)">-- Make the view editable</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">CREATE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">OR</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> REPLACE </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">RULE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"_DELETE"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">AS</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">ON</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">DELETE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">TO</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"PGHP"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">infra_portoes DO INSTEAD
  </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">DELETE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">FROM</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"PGHP"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"infraestruturas_pontos"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">WHERE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> gid </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">=</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> old</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">gid</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">;</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">

</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">CREATE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">OR</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> REPLACE </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">RULE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"_INSERT"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">AS</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">ON</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">INSERT</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">TO</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"PGHP"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">infra_portoes DO INSTEAD
  </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">INSERT</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">INTO</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"PGHP"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"infraestruturas_pontos"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">(</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"gid"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"classe"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"nome"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"geom"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">)</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
    </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">VALUES</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">(</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">NEW</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"gid"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">'portoes'</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">NEW</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"nome"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">NEW</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"geom"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">);</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">

</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">CREATE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">OR</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> REPLACE </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">RULE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"_UPDATE"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">AS</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">ON</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">UPDATE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">TO</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"PGHP"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">infra_portoes DO INSTEAD
  </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">UPDATE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"PGHP"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"infraestruturas"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">SET</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> 
    </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"gid"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">=</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> NEW</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"gid"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
    </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"classe"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">=</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">'portoes'</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
    </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"nome"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">=</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> NEW</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"nome"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">,</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
    </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"geom"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">=</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> NEW</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:maroon">"geom"</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">
  </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(138,74,11)">WHERE</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> gid </span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">=</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"> NEW</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">.</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black">gid</span><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(20,86,128)">;</span></code></pre>
<pre class="" 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);word-wrap:normal;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);white-space:inherit"><span class="" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:black"><br>
</span></code></pre></div></div>