Bug report #16446
Updated by Giovanni Manghi about 7 years ago
Hi,
I can't make N:M relation working.
In attachment you'll find a small SQL script to create simple tables with restrictions as described here : https://github.com/qgis/QGIS/pull/2522
and a small QGIS project.
There are two issues :
When I create an observation, I can't create an author (auteur) linked to it
When I create an observation, I can't make a relation to an existing author (auteur). There is an error message because the new observation's id is not inserted in the relation table but a null value is inserted which violates not-null constraint.
I can't make N:M relation working.
In attachment you'll find a small SQL script to create simple tables with restrictions as described here : https://github.com/qgis/QGIS/pull/2522
and a small QGIS project.
There are two issues :
When I create an observation, I can't create an author (auteur) linked to it
When I create an observation, I can't make a relation to an existing author (auteur). There is an error message because the new observation's id is not inserted in the relation table but a null value is inserted which violates not-null constraint.