LP 1568046: Replace last two uses of connectby with other function calls. user/dyrcona/lp1568046-kill-connectby-with-fire
authorJason Stephenson <jason@sigio.com>
Fri, 1 Jul 2016 17:13:16 +0000 (13:13 -0400)
committerJason Stephenson <jason@sigio.com>
Sat, 2 Jul 2016 07:29:29 +0000 (03:29 -0400)
commit72dbfcb31be8bb5a159b6bcdc2317227cd831743
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>
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]