Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k9Vor-0002dr-M1 for pgsql-bugs@arkaria.postgresql.org; Sat, 22 Aug 2020 15:52:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k9Voq-0001vg-Aw for pgsql-bugs@arkaria.postgresql.org; Sat, 22 Aug 2020 15:52:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k9Voq-0001vZ-4J for pgsql-bugs@lists.postgresql.org; Sat, 22 Aug 2020 15:52:36 +0000 Received: from mout.kundenserver.de ([217.72.192.73]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k9Vol-000470-UJ for pgsql-bugs@lists.postgresql.org; Sat, 22 Aug 2020 15:52:35 +0000 Received: from feivel.credativ.lan ([84.165.67.108]) by mrelayeu.kundenserver.de (mreue108 [212.227.15.183]) with ESMTPSA (Nemesis) id 1MfHMj-1kph3L3qep-00gssq; Sat, 22 Aug 2020 17:52:25 +0200 Received: from localhost (localhost [127.0.0.1]) by feivel.credativ.lan (Postfix) with ESMTP id 4108EE0107; Sat, 22 Aug 2020 17:52:23 +0200 (CEST) Message-ID: <203b64f3ec14fcfec8d31fe3646f9037ad97b713.camel@postgresql.org> Subject: Re: BUG #16547: ECPG can't CALL the procedure which has INOUT parameter From: Michael Meskes To: Bruce Momjian , egashira.yusuke@jp.fujitsu.com, pgsql-bugs@lists.postgresql.org Date: Sat, 22 Aug 2020 17:52:23 +0200 In-Reply-To: <20200822005954.GP13363@momjian.us> References: <16547-0d8cd56ecb46f943@postgresql.org> <20200822005954.GP13363@momjian.us> Organization: PostgreSQL Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.4-2 MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K1:7OHcTFOmTwKvIYeWDc6XFp3C9A8ZhwQK2gA00YUaKXVd7QVsppy Bhw2q/jcQY+6emwJQBLYYdcCFcDlRmJmfG5gAthEvZkJWYDl00wNtGKRYPmtgbwxrF36Jx4 QnWbrGaXIWdJfV1KmWGTPZ3flsmCG9ceHU2QjLc+7twuUP2AcfrREejWBJnE4PgMPF4ep0D L2uYH5rmEzmCpizY/83ug== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:FP1A2WxMM3I=:GpJgjL3yKd97spqCawJnoc IakNFsAC1kHHiEh6JiC0sUQRTA2XqBDrGS1l/aMZjVbITFdofTLic1xsPwRllMwAwUJVNNNp+ TapDgydPwabPF2boOeZ97RDCj/d3t9Z3o0cRtBc0oq9zQazxtp6vX8i8J675K+R+V9TPlvQg+ EMHYHEmDl0y01TSTfBiYgMaJ7HnC+o/GyjYeOkPzkUDFRpeke78VY8TgC+fsTDtlxw0i4MD7Y 4KUHmIXDcv8gmjyTYmILztedfSXFuqV8Kz6k2d8fanavwOMESK13/h1sRe1w71kUtQ3tqS0TE nNN1MiB7toEcN31nsQvHJoiJiGfnppOhLETeKjeLH9RgnQovCGvLN+pfEwe//uPRjhjYvVBem dHYTYE6R9WqcVU2dGEDtNhBqfT202EzN6XmPMcVRUcn1dLaiXXHu+UYu5CzM8igqe6CXsKECv ihY04gl4Wy6z2t2uYPj3tkS3wbDO1HMpF8yaFKPTQlkSuFxQg6gBh8nfX5u1VLM/KM2ePryqQ SbkjLQtGs1H3NMAyQjPdNeG/hArqk6htWSJNy8IK15/45RwthLxYSr8DWc5cLBbkIqpAn0lgi 6uHb8jpw6pWjM5DKfzwRT8TdctGW6l5S53kBarmFEpOw609YDQLIiZid+b+Wkl3A2LZNJGzbp 9Kw00JOgLzHu4AB5aH9uiypOAgBtKy0mLVMxqJMhxLWBna9hgWI5GvgrEOYbtGZ7marGSe1ap FG7QZp81jQbKhzPr5SD4lhyhhV3L535gFhDRPhI/LTcTcnYPVEY0DMyB8Xi0whXVomfjTaK+d EzgiHTI2aTX1ma4T29itCcZ7YrroXDbUwbwg1rwHxFSzPWOIlvj/FDoej6hDzLw6UtoQi88 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > > ... > > Also, I found the patch[1] introducing "INTO" clause in CALL of > > ECPG. > > However, the patch changes the EXC SQL CALL statement to always > > require INTO > > clause. > > > > [1] > > https://www.postgresql.org/message-id/CAE9k0P%3DGQFjfy9jHCPDw4Eh_xE%3DNw%3D9y4f-CuTZp1L%2B6vEHwFg%40mail.gmail.com > > This looks like something we should either fix or document. Michael > Meskes, do you have an opinion? Yes, I think it should definitely be fixed. In fact I was looking into it and iirc the patch mentioned had a couple issues but could be a good base for the fix. Unfortunately I have not found the time yet to take care of it. So in short, hopefully we can fix it shortly. Michael -- Michael Meskes Michael at Fam-Meskes dot De Michael at Meskes dot (De|Com|Net|Org) Meskes at (Debian|Postgresql) dot Org