Comment 10 for bug 1568046

Revision history for this message
Jason Stephenson (jstephenson) wrote :

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.