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