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