QGIS » QGIS Application

can you provide sample data?

Schema is attached to the ticket, to populate it with sample data just execute the following statements.

insert into maps (ID, NAME) values(1, "map1");
insert into layers (ID, NAME, MAP_ID) values(1, "layer1", 1);

-------------------------------------------------------------
After that you can add LINESTRING layer in QGIS using view with name "map1_l1_l" and draw a line.
And after that add POINT layer in QGIS using view with name "map1_l1_s" and reproduce my error.

As you can see from section:

query := 'create or replace rule '|| view_name || 'i ' || '
as on insert to '|| view_name || '
do instead (
insert into layer_elements (layer_id, id, name) values('|| lid ||', NEW.id, NEW.name);
insert into ' || le ||' (id, the_geom) values(NEW.id, NEW.the_geom);
)';

The ID is not calculated automaticaly, I'm using the provided one, without defaults.

PostGIS version - 1.4.0, Postgresql version - 8.2.14, QGIS version - 1.3.0

Sorry, little mistake in queries. Following are correct ones.

insert into maps (ID, NAME) values(1, 'map1');

insert into layers (ID, NAME, MAP_ID) values(1, 'layer1', 1);

Replying to [comment:5 jef]:

should be fixed in 8a66aee7 (SVN r12236) - hopefully without breaking something else.

actually it was. 58c68efc (SVN r12419) roll 8a66aee7 (SVN r12236) back and deduces the default value the column the id column of the view is derived from and uses that to retrieve new ids.