[Qgis-developer] Postgis View Insert problem

[Jože Detečnik]

I have rule on view  to insert values in database. I noticed that something
change since version 1.7.4.

 

CREATE OR REPLACE RULE "_INSERT" AS

    ON INSERT TO gji_kanalizacija_itl DO INSTEAD  INSERT INTO gji_itl
(tip_spr, id_gurs, sif_vrste, cc_klas, topo, nat_yx, z, nat_z, gji, vir,
dat_vir, mat_st, mat_gjs, id_el, dat_el, dim_yx, dim_z, opu, atr1, atr2,
atr3, atr4, atr5, opis, datum_spr, slika, tip_zasuna, oznaka, os, sprememba,
ob_id, objekt_tip, x, y, geom, obj_tip1, obj_lokac, obj_oblika, id_upr,
ime_oddaje) 

  VALUES (new.tip_spr, new.id_gurs, new.sif_vrste, new.cc_klas, new.topo,
new.nat_yx, new.z, new.nat_z, new.gji, new.vir, new.dat_vir, new.mat_st,
new.mat_gjs, new.id_el, new.dat_el, new.dim_yx, new.dim_z, new.opu,
new.atr1, new.atr2, new.atr3, new.atr4, new.atr5, new.opis, new.datum_spr,
new.slika, new.tip_zasuna, new.oznaka, new.os, new.sprememba, new.ob_id,
new.objekt_tip, new.x, new.y, new.geom, new.obj_tip1, new.obj_lokac,
new.obj_oblika, new.id_upr, new.ime_oddaje);

 

1.8 not save Default value to field id_upr defined
(nextval('gji_id_upr_seq'::regclass)) but 1.7.4 same job did OK.

 

Can anybody confirm that behaviour. 

 

Best regards, Joze.

 

Opis: Logo_KomunalaSlovenjGradec_2012cemail

 

           Jože Detečnik

                          vodja informatike

 

                 JAVNO PODJETJE KOMUNALA SLOVENJ GRADEC d.o.o.

                 PAMEČE 177 A, SI-2380 SLOVENJ GRADEC

                  telefon:   ++386 (0)2 881-20-25

                  mobi:      ++386 (0)41-748-005

                  faks:        ++386 (0)2 821-20-40

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20120601/212461b6/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: application/octet-stream
Size: 7276 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20120601/212461b6/attachment.obj>