bareos: master 2bf0e4d7

Author Committer Branch Timestamp Parent
arogge Bareos Bot master 2025-11-18 16:35 master 03031eee Pending
Changeset dir: refactor status subscription queries

these used two views in the database previously. As it turned out,
changing these requires a schema upgrade. As this is largely unfeasible,
we use a WITH-clause in the query that declares the same relations the
views have.
This removes the need for the views in the database and thus allows to
change the underlying queries without a schema change.
mod - core/src/cats/bdb_query_enum_class.h Diff File
mod - core/src/cats/bdb_query_names.inc Diff File
add - core/src/cats/dml/0084_subscription_with_clause_0 Diff File
mod - core/src/cats/postgresql_queries.inc Diff File
mod - core/src/dird/ua_status.cc Diff File