Search Postgresql Archives

Re: PL/pgSQL's "open cur for execute" provides workarouned... Re: cursors with prepared statements

Subject: Re: PL/pgSQL's "open cur for execute" provides workarouned... Re: cursors with prepared statements
From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>
Date: Sun, 16 Apr 2023 11:39:15 -0700
Cc: "David G. Johnston" <david.g.johnston@xxxxxxxxx>, Peter Eisentraut <peter.eisentraut@xxxxxxxxxxxxxxx>
Feedback-id: i76984098:Fastmail
In-reply-to: <F26A566A-821F-43AC-8D67-9BEF5DB958BC@yugabyte.com>
References: <42DB8C32-AC45-4735-8A47-4D7D4DB93E2E@yugabyte.com> <CAKFQuwaXMwZGdBZAEW8qusOXXJn=8ROOnrF_7-iYY2+tVC-fkg@mail.gmail.com> <C08CD8DD-1B09-433D-A90C-32F4A09615C3@yugabyte.com> <F26A566A-821F-43AC-8D67-9BEF5DB958BC@yugabyte.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0

On 4/16/23 11:02, Bryn Llewellyn wrote:> statement fails but doing thisusing PL/pgSQL succeeds.


What's going on under the covers?


Pretty sure:

https://www.postgresql.org/docs/current/spi.html

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

Follow-Ups:
- Re: PL/pgSQL's "open cur for execute" provides workarouned... Re: cursors with prepared statements
  - From: Bryn Llewellyn

References:
- Re: cursors with prepared statements
  - From: Bryn Llewellyn
- Re: cursors with prepared statements
  - From: David G. Johnston
- Re: cursors with prepared statements
  - From: Bryn Llewellyn
- PL/pgSQL's "open cur for execute" provides workarouned... Re: cursors with prepared statements
  - From: Bryn Llewellyn