https://issues.qgis.org/https://issues.qgis.org/favicon.ico2018-01-17T09:33:26ZQGIS Issue TrackingQGIS Application - Bug report #17869: database check constraints on several fields can't be evaluated correctly on update in transaction mode https://issues.qgis.org/issues/17869?journal_id=858722018-01-17T09:33:26ZRegis Haubourgregis.haubourg@oslandia.com
<ul></ul><p>We found another case where this behavior is not good. When database has a audit trigger log, each form update will generate as many transactions as changed fields. This adds weight a lot the audit log and makes it harder to query since it is not possible to associate a transaction with a user update action.</p> QGIS Application - Bug report #17869: database check constraints on several fields can't be evaluated correctly on update in transaction mode https://issues.qgis.org/issues/17869?journal_id=858942018-01-17T19:38:44ZJürgen Fischerjef@norbit.de
<ul><li><strong>Assignee</strong> deleted (<del><i>Jürgen Fischer</i></del>)</li></ul> QGIS Application - Bug report #17869: database check constraints on several fields can't be evaluated correctly on update in transaction mode https://issues.qgis.org/issues/17869?journal_id=859452018-01-19T19:21:46ZDenis Rouzauddenis.rouzaud@gmail.com
<ul><li><strong>Assignee</strong> set to <i>David Signer</i></li></ul> QGIS Application - Bug report #17869: database check constraints on several fields can't be evaluated correctly on update in transaction mode https://issues.qgis.org/issues/17869?journal_id=859642018-01-20T21:33:29ZRegis Haubourgregis.haubourg@oslandia.com
<ul><li><strong>Assignee</strong> changed from <i>David Signer</i> to <i>Paul Blottiere</i></li></ul><p>Hi Denis, <br />Paul already has a branch ready here <a class="external" href="https://github.com/pblottiere/QGIS/tree/bugfix_transaction_constraints">https://github.com/pblottiere/QGIS/tree/bugfix_transaction_constraints</a><br />Any feedback welcome.</p> QGIS Application - Bug report #17869: database check constraints on several fields can't be evaluated correctly on update in transaction mode https://issues.qgis.org/issues/17869?journal_id=859992018-01-22T11:43:41ZDenis Rouzauddenis.rouzaud@gmail.com
<ul></ul><p>feel free to PR</p> QGIS Application - Bug report #17869: database check constraints on several fields can't be evaluated correctly on update in transaction mode https://issues.qgis.org/issues/17869?journal_id=860842018-01-23T16:25:50ZRegis Haubourgregis.haubourg@oslandia.com
<ul></ul><p>and PR is here :) [[<a class="external" href="https://github.com/qgis/QGIS/pull/6142">https://github.com/qgis/QGIS/pull/6142</a>]]</p> QGIS Application - Bug report #17869: database check constraints on several fields can't be evaluated correctly on update in transaction mode https://issues.qgis.org/issues/17869?journal_id=863062018-01-29T08:18:58ZPaul Blottiereblottiere.paul@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Closed</i></li><li><strong>% Done</strong> changed from <i>0</i> to <i>100</i></li></ul><p>Applied in changeset <a class="changeset" href="https://issues.qgis.org/projects/qgis/repository/revisions/c1fac42518440680f246250024107201446d8adc" title="Update all attributes in a single transaction Fixes #17869">qgis|c1fac42518440680f246250024107201446d8adc</a>.</p> QGIS Application - Bug report #17869: database check constraints on several fields can't be evaluated correctly on update in transaction mode https://issues.qgis.org/issues/17869?journal_id=870292018-02-21T20:51:34ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Resolution</strong> set to <i>fixed/implemented</i></li></ul>