From: Tom Lane <tgl@sss.pgh.pa.us>
To: wlaunhardt@web.de
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18116: This is definitiv a BUG in INOUT parameter in stored
 procedures in Postgres 12.16
In-reply-to: <18116-0a17d1321c9d94ea@postgresql.org>
References: <18116-0a17d1321c9d94ea@postgresql.org>
Comments: In-reply-to PG Bug reporting form <noreply@postgresql.org>
	message dated "Mon, 18 Sep 2023 11:46:22 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <114626.1695046221.1@sss.pgh.pa.us>
Date: Mon, 18 Sep 2023 10:10:21 -0400
Message-ID: <114627.1695046221@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/114627.1695046221%40sss.pgh.pa.us>
Precedence: bulk

PG Bug reporting form <noreply@postgresql.org> writes:
> Please don't send me that again - it is a BUG ! :

Maybe, but you haven't shown us a reproducible example.
What I get from the fragments you gave here is

ERROR:  ptest(text[]) is not a procedure
LINE 1: CALL ptest( test )
             ^
HINT:  To call a function, use SELECT.
QUERY:  CALL ptest( test )
CONTEXT:  PL/pgSQL function inline_code_block line 6 at CALL

I suspect that the underlying problem may involve a SQL declaration
for "ptest" that doesn't match what the C code does, so I'm not going
to guess at what you actually used as the SQL declaration.  But
clearly it's not what you wrote here.

			regards, tom lane