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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
