Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> 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