Redmine Dashboards

GitHub tests are failing when running unit tests with postgresql. It complains

WARNING: Rails was not able to disable referential integrity.

This is most likely caused due to missing permissions.
Rails needs superuser privileges to disable referential integrity.

    cause: PG::InsufficientPrivilege: ERROR:  permission denied: "RI_ConstraintTrigger_a_17929" is a system trigger


rake aborted!
ActiveRecord::InvalidForeignKey: PG::ForeignKeyViolation: ERROR:  insert or update on table "dashboard_roles" violates foreign key constraint "fk_rails_a8da46db10"
DETAIL:  Key (role_id)=(1) is not present in table "roles".
/home/runner/work/redmine_dashboards/redmine_dashboards/redmine/plugins/redmine_dashboards/test/test_helper.rb:61:in `block in fixtures'
/home/runner/work/redmine_dashboards/redmine_dashboards/redmine/plugins/redmine_dashboards/test/test_helper.rb:60:in `each'
/home/runner/work/redmine_dashboards/redmine_dashboards/redmine/plugins/redmine_dashboards/test/test_helper.rb:60:in `fixtures'
/home/runner/work/redmine_dashboards/redmine_dashboards/redmine/plugins/redmine_dashboards/test/unit/dashboard_content_test.rb:27:in `<class:DashboardContentTest>'
/home/runner/work/redmine_dashboards/redmine_dashboards/redmine/plugins/redmine_dashboards/test/unit/dashboard_content_test.rb:26:in `<top (required)>'
/home/runner/work/redmine_dashboards/redmine_dashboards/redmine/lib/tasks/redmine.rake:182:in `block (4 levels) in <top (required)>'
/opt/hostedtoolcache/Ruby/3.1.4/x64/bin/bundle:25:in `load'
/opt/hostedtoolcache/Ruby/3.1.4/x64/bin/bundle:25:in `<main>'

See https://github.com/xmera-circle/redmine_project_types_relations/actions/workflows/5-0-stable.yml for details.