DECLARE cur CURSOR with hold FOR SELECT * FROM t;
the "with hold" is designed for this purpose. sorry for this
interruption.
On Sun, Mar 10, 2019 at 4:14 PM Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> wrote:
> for example:
> begin;
> declare cur cursor for select * from t;
> insert into t2 values(...);
> fetch next cur;
> commit;
>
> // after this, I can't fetch cur any more.
>
> My question are:
> 1. Is this must in principle? or it is easy to implement as this in PG?
> 2. Any bad thing would happen if I keep the named portal (for the cursor)
> available even the transaction is commit, so that I can fetch the cursor
> after the transaction is committed?
>
> Thanks
>