Re: Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt.

On Wed, Aug 12, 2020 at 8:21 PM Dave Cramer wrote: > > > On Wed, 12 Aug 2020 at 08:14, Andy Fan wrote: > >> >> >> On Wed, Aug 12, 2020 at 8:11 PM Andy Fan >> wrote: >> >>> >>> >>> On Wed, Aug 12, 2020 at 5:54 PM Dave Cramer >>> wrote: >>> On Tue, 11 Aug 2020 at 22:33, Andy

Re: Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt.

On Wed, 12 Aug 2020 at 08:14, Andy Fan wrote: > > > On Wed, Aug 12, 2020 at 8:11 PM Andy Fan wrote: > >> >> >> On Wed, Aug 12, 2020 at 5:54 PM Dave Cramer >> wrote: >> >>> >>> >>> >>> On Tue, 11 Aug 2020 at 22:33, Andy Fan wrote: >>> On Mon, Jul 27, 2020 at 11:57 AM Andy Fan >>

Re: Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt.

On Wed, Aug 12, 2020 at 8:11 PM Andy Fan wrote: > > > On Wed, Aug 12, 2020 at 5:54 PM Dave Cramer > wrote: > >> >> >> >> On Tue, 11 Aug 2020 at 22:33, Andy Fan wrote: >> >>> >>> >>> On Mon, Jul 27, 2020 at 11:57 AM Andy Fan >>> wrote: >>> > 2. Currently I want to add a new GUC paramet

Re: Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt.

On Wed, Aug 12, 2020 at 5:54 PM Dave Cramer wrote: > > > > On Tue, 11 Aug 2020 at 22:33, Andy Fan wrote: > >> >> >> On Mon, Jul 27, 2020 at 11:57 AM Andy Fan >> wrote: >> >>> 2. Currently I want to add a new GUC parameter, if set it to true, server will create a holdable portal,

Re: Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt.

On Tue, 11 Aug 2020 at 22:33, Andy Fan wrote: > > > On Mon, Jul 27, 2020 at 11:57 AM Andy Fan > wrote: > >> >>> 2. Currently I want to add a new GUC parameter, if set it to true, >>> server will >>> create a holdable portal, or else nothing changed. Then let the user >>> set >>> it to true in t

Re: Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt.

On Mon, Jul 27, 2020 at 11:57 AM Andy Fan wrote: > >> 2. Currently I want to add a new GUC parameter, if set it to true, server >> will >> create a holdable portal, or else nothing changed. Then let the user set >> it to true in the above case and reset it to false afterward. Is there >> any is

Re: Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt.

> > > 2. Currently I want to add a new GUC parameter, if set it to true, server > will > create a holdable portal, or else nothing changed. Then let the user set > it to true in the above case and reset it to false afterward. Is there > any issue > with this method? > > I forget to say in this ca

Allows Extend Protocol support CURSOR_OPT_HOLD with prepared stmt.

I have a user case like this: rs = prepared_stmt.execute(1); while(rs.next()) { // do something with the result and commit the transaction. conn.commit(); } The driver used the extended protocol in this case. It works like this: 1). Parse -> PreparedStmt. 2). Bind -> Bind the prepared st