Shachar Shemesh wrote:
> Just out of curiosity, how do I manually destroy the cursor when it's no
> longer needed? Just do "close refcursor"?
Yup:
http://www.postgresql.org/docs/current/static/sql-close.html
> Also, does this copy take place when the table is changed, or as soon as
> the transaction ends? If the former, it may not matter.
IIRC it is the latter.
Joe
