[InterNetNews/inn] 53fb2c: ovsqlite-util: Fix how transactions are handled

Julien ÉLIE noreply at github.com
Sat Mar 18 10:20:50 UTC 2023


  Branch: refs/heads/main
  Home:   https://github.com/InterNetNews/inn
  Commit: 53fb2ca8841a2a1a245c0527ae27fe8cf714435d
      https://github.com/InterNetNews/inn/commit/53fb2ca8841a2a1a245c0527ae27fe8cf714435d
  Author: Julien ÉLIE <Julien-Elie at users.noreply.github.com>
  Date:   2023-03-18 (Sat, 18 Mar 2023)

  Changed paths:
    M storage/ovsqlite/ovsqlite-util.in

  Log Message:
  -----------
  ovsqlite-util: Fix how transactions are handled

Turning enforcement of foreign key constraints on or off is an SQLite
operation that can only be done outside of any transaction.

When the AutoCommit attribute is false, the do method of the database
handle will helpfully start a transaction if one isn't active already.
That is why this AutoCommit attribute has to be set to true for that
operation.

Patch from Bo Lindbergh.


  Commit: e8e8b09cc49ab9dc8b81bc1b92766356bac4ef4d
      https://github.com/InterNetNews/inn/commit/e8e8b09cc49ab9dc8b81bc1b92766356bac4ef4d
  Author: Julien ÉLIE <Julien-Elie at users.noreply.github.com>
  Date:   2023-03-18 (Sat, 18 Mar 2023)

  Changed paths:
    M doc/pod/ovdb_stat.pod
    M doc/pod/ovsqlite-util.pod
    M doc/pod/tdx-util.pod

  Log Message:
  -----------
  Mention inndf in overview documentation

inndf -n gives the number of stored overview data.


Compare: https://github.com/InterNetNews/inn/compare/85cc3c205d07...e8e8b09cc49a


More information about the inn-committers mailing list