]> git.evergreen-ils.org Git - working/Evergreen.git/commit
LP#1568046: Replace last two uses of connectby with other function calls.
authorJason Stephenson <jason@sigio.com>
Fri, 1 Jul 2016 17:13:16 +0000 (13:13 -0400)
committerBen Shum <ben@evergreener.net>
Tue, 5 Jul 2016 05:13:03 +0000 (01:13 -0400)
commit499d69d64e7c7b660ee1dffc250f8f9552df8daa
tree7ab0607bc9329bc5e6e27c01482f4948240bb0d0
parent167b0c93155a3f5e294254c6599db70ee8116c45
LP#1568046: Replace last two uses of connectby with other function calls.

Modify permission functions permission.usr_has_perm_at_nd and
permission.usr_has_perm_at_all_nd to no longer require the connectby
function from the tablefunc extension.  The connectby functionality is
replaced by existing database functions to retrieve org. unit
descendants.

This change removes the need to load the tablefunc extension, so it is
dropped from the create scripts.  The upgrade script does not remove
the extension as sites may be using connectby or other functions from
the extension.

Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Ben Shum <ben@evergreener.net>
Open-ILS/src/sql/Pg/006.schema.permissions.sql
Open-ILS/src/sql/Pg/create_database_contribs.sql
Open-ILS/src/sql/Pg/create_database_extensions.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.function.perm_functions_without_connectby.sql [new file with mode: 0644]
docs/RELEASE_NOTES_NEXT/Administration/lp1568046-tablefunc-extension-removed.adoc [new file with mode: 0644]