I have 2 postgis layers with a relation and uuid’s as pk.
when collecting data sometime the feature of the point laters is not added and other times the feature with no geometry is not added.
The job log gives this error: Erroneous query: SAVEPOINT “qgis1b038cdf9aa545cca3c7” returned 7 [ERROR: SAVEPOINT can only be used in transaction blocks
Eroneous query: COMMIT TRANSACTION returned 7 [ERROR: insert or update on table “stabiliteit” violates foreign key constraint “fk_struik_stabiliteit”
DETAIL: Key (struik_uuid)=(0db75c28-48b1-4d58-8ab5-c5ccb8371c9e) is not present in table “struik”.
but it is present.
Does someone know what i’m doing wrong?
In qgis everyting works expected
Imported from GitHub discussion by @ThomasDV1984 on 2024-05-15T19:29:06Z