Adrian Klaver <adrian.klaver@xxxxxxxxxxx> writes: > On 2/26/24 04:26, Sasmit Utkarsh wrote: >> ***Facing the below issue, while calling the below procedures in public >> and non-public schema *shc* for ( *shc_uadmin* user) > 1) From the error message: > "ERROR: procedure sql_select_size_procedure(text, > integer, unknown) does not exist" > "No procedure matches the given name and argument types" This perhaps would be better understood as "there is no matching procedure in the current search_path". The fact that it works as one user and not as another could be explained if the users have different search paths. regards, tom lane
