QGIS » QGIS Application

no video attached.
regards

Hi,.
I have similar problem in Windows QGIS 2.8.9 and 2.14.3 - when I start QGIS and I open .qgs project, snapping is working fine (according to 'snapping options' saved in .qgs project). But if I reload the same project (without restarting QGIS) snapping is not working. I have to set it again in 'snapping options' window or shut QGIS, start it again and load projekt - then snapping is working.
I don't see this problem on Ubuntu 12.04 (QGIS 2.8.2) but it is in Windows in QGIS 2.8.9 LTR and 2.14.3.
Regards.

Hmm I am unable to reproduce... here is what I tried:

1) start QGIS, create a new temporary scratch layer (with line geometry)
2) open snapping options, use advanced mode, using snapping to vertex, 20 pixels tolerance
3) create a new line feature in the layer
4) snapping works as expected
5) save the new line feature
6) snapping still works as expected

Could you please verify whether this works for you too? Maybe there is something else involved, something to do with project configuration or data storage...

Hi again,

We can confirm that the steps above work as expected for scratch layers. Regarding the QGIS project, all our tests have been done starting from an empty project (blank paper icon).

In our case the problem seems to be related with the interaction between QGIS and the PostgreSQL database regarding primary keys. In [1] we share a minimal setup to replicate the exact bug.

The steps to replicate the error are:
1) Execute the setup shared in [1] on PostgreSQL (for example using PgAdmin3).
2) Execute "Layer" > "Add Layer" > "Add PostGIS Layers"
3) Load both "test.snapping_working" and "test.snapping_broken" tables.
4) Open snapping options, use advanced mode, using snapping to vertex, 20 pixels tolerance for both layers
5) Create a new 'snapping_working' feature and DO NOT save layer yet
6) Snapping works as expected
7) Save the changes on the layer 'snapping_working'
8) Snapping works as expected
9) Create a new 'snapping_broken' feature and DO NOT save layer yet
10) Snapping works as expected
11) Save the changes on the layer 'snapping_broken'
12) Snapping does not work

• In step 5, before clicking ok, the id field has the value "nextval('test.snapping_working_id_seq'::regclass)". That means that QGIS already passes an expression to the PostgreSQL databases.
• In step 9, before clicking ok, the id field is empty (i.e., its values is NULL). That means that the condition inside 'test.generate_id()' trigger function is valid and the id is set to 99.

From the previous test case, we concluded that the snapping error happens somehow when the value of the primary key is set up inside a trigger.

[1] Code to replicate the issue

-- Create schema to hold the testing tables
DROP SCHEMA IF EXISTS test CASCADE;
CREATE SCHEMA test;

/*
This table has a line geometry and its primary key is defined
using a sequence of bigints. Therefore, bigserial will always
automatically increment the id value.
*/
CREATE TABLE test.snapping_working
(
id bigserial NOT NULL,
geom geometry(LineString,32628),
CONSTRAINT snapping_working_pkey PRIMARY KEY (id)
);

/*
This table has a line geometry and its primary key is defined
using a bigint type. This time, the id value is generated
by a custom trigger.
*/
CREATE TABLE test.snapping_broken
(
id bigint NOT NULL,
geom geometry(LineString,32628),
CONSTRAINT snapping_broken_pkey PRIMARY KEY (id)
);

-- ID generation trigger function
CREATE OR REPLACE FUNCTION test.generate_id() RETURNS trigger AS
$$
DECLARE
code integer := 99;
check_code bigint;
BEGIN

IF NEW.id IS NULL THEN
    NEW.id := code;
  END IF;

RETURN NEW;
END;
$$ 
LANGUAGE plpgsql SECURITY DEFINER;

-- Define trigger
CREATE TRIGGER aa_set_id
BEFORE INSERT
ON test.snapping_broken
FOR EACH ROW
EXECUTE PROCEDURE test.generate_id();