Re: Clarity regarding the procedures call in postgresql for public and non-public schema - Mailing list pgsql-general

From Tom Lane
Subject Re: Clarity regarding the procedures call in postgresql for public and non-public schema
Date
Msg-id 1812658.1708965551@sss.pgh.pa.us
Whole thread Raw
In response to Re: Clarity regarding the procedures call in postgresql for public and non-public schema  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Adrian Klaver <adrian.klaver@aklaver.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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pPL/pgSQL restriction on characters for copying types?
Next
From: Thiemo Kellner
Date:
Subject: Re: pPL/pgSQL restriction on characters for copying types?