Re: Clarity regarding the procedures call in postgresql for public and non-public schema

On 2/26/24 04:26, Sasmit Utkarsh wrote:
> Hi Postgresql Team,
> 
> ***Facing the below issue, while calling the below procedures in public 
> and non-public schema *shc* for ( *shc_uadmin* user)
> 

> *<3>0164503{00000000-0000-0000-0000-000000000000.noterm}-[ERROR] PREPARE 
> failed for RIAT! ERROR:  procedure sql_select_size_procedure(text, 
> integer, unknown) does not exist
> LINE 1: CALL SQL_select_size_procedure($1, $2, NULL)
>               ^
> HINT:  No procedure matches the given name and argument types. You might 
> need to add explicit type casts.*
>   [../tpfasm.c:13961:SQL_init_db_connection]
> <7>0164503{00000000-0000-0000-0000-000000000000.noterm}-ROLLBACK TRANSACTION

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"

 From the call:

CALL SQL_select_size_procedure($1, $2, NULL)

You might try:

CALL SQL_select_size_procedure($1, $2, NULL::text)

2) Any clue as to where this:

"...failed for RIAT..."

is comimg from?



-- 
Adrian Klaver
adrian.klaver@aklaver.com