Re: Help to review the with X cursor option.

2019-04-24 Thread alex lock
On Thu, Apr 25, 2019 at 9:53 AM alex lock wrote: > > > that's something I want to change, as I said at the beginning. include > avoid some memory release (like the EState and so on), snapshot release. > > I check my original statement, I found "snapshot release" was missed, that obviously

Re: Help to review the with X cursor option.

2019-04-24 Thread alex lock
On Wed, Apr 24, 2019 at 11:30 PM Tom Lane wrote: > alex lock writes: > > The cursor means something like declare c cursor for select * from t; > > The holdable cursor means declare c cursor WITH HOLD for select * from t; > > > Holdable cursor is good at transaction, user can still access it

Re: Help to review the with X cursor option.

2019-04-24 Thread Tom Lane
alex lock writes: > The cursor means something like declare c cursor for select * from t; > The holdable cursor means declare c cursor WITH HOLD for select * from t; > Holdable cursor is good at transaction, user can still access it after the > transaction is commit. But it is bad at it have