Register Patron will not load for me in the browser staff client with a Pg 9.5 database. Checking on the two functions that still use connectby, it looks like permission.usr_has_perm_at_all_nd is the culprit:
select permission.usr_has_perm_at_all_nd(223, 'ABORT_TRANSIT');
ERROR: invalid return type
DETAIL: SQL key field type text does not match return key field type integer.
CONTEXT: PL/pgSQL function permission.usr_has_perm_at_all_nd(integer,text) line 28 at FOR over SELECT rows
Concerto loads, but calling the function gives the above result.
I think we should get rid the remaining connectby calls, and then we can also drop a dependency.
Register Patron will not load for me in the browser staff client with a Pg 9.5 database. Checking on the two functions that still use connectby, it looks like permission. usr_has_ perm_at_ all_nd is the culprit:
select permission. usr_has_ perm_at_ all_nd( 223, 'ABORT_TRANSIT'); usr_has_ perm_at_ all_nd( integer, text) line 28 at FOR over SELECT rows
ERROR: invalid return type
DETAIL: SQL key field type text does not match return key field type integer.
CONTEXT: PL/pgSQL function permission.
Concerto loads, but calling the function gives the above result.
I think we should get rid the remaining connectby calls, and then we can also drop a dependency.