]> git.evergreen-ils.org Git - Evergreen.git/commit
LP#1768141 - Mark permission.grp_descendants STABLE.
authorChris Sharp <csharp@georgialibraries.org>
Mon, 20 May 2019 20:14:00 +0000 (16:14 -0400)
committerJason Boyer <jboyer@equinoxinitiative.org>
Tue, 1 Oct 2019 18:57:52 +0000 (14:57 -0400)
commit30a95eeaa3bb6a2737b2d3b1405f79b7aa44c9f3
tree209b44055bec31b33b5e922a08f3f0442e1e717c
parent42ec4917c0f0bb0fe034e1b09d5ba0ef6cf0021e
LP#1768141 - Mark permission.grp_descendants STABLE.

Quoting Galen Charlton's comments on the bug report:

The database function permission.grp_descendants should
be marked stable; it qualifies, and doing so should allow
PostgreSQL to improve query plans. One example of a query
that would benefit is searching by patron profile (a la
bug 1497322)

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Signed-off-by: Jason Boyer <jboyer@equinoxinitiative.org>
Open-ILS/src/sql/Pg/006.schema.permissions.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.mark_perm_grp_descendants_stable.sql [new file with mode: 0644]