There is a misstatement in the CLOSE reference page, now that we have cursors that might outlive their creating transactions. A patch is attached that fixes this (suggestions on better wording are welcome).
-Neil
Index: doc/src/sgml/ref/close.sgml =================================================================== RCS file: /home/neil/cvsup/cvs/pgsql-server/doc/src/sgml/ref/close.sgml,v retrieving revision 1.14 diff -c -r1.14 close.sgml *** doc/src/sgml/ref/close.sgml 15 Apr 2003 13:25:08 -0000 1.14 --- doc/src/sgml/ref/close.sgml 9 Aug 2003 08:34:36 -0000 *************** *** 31,39 **** </para> <para> ! Every open cursor is implicitly closed when a transaction is ! terminated by <command>COMMIT</command> or ! <command>ROLLBACK</command>. </para> </refsect1> --- 31,43 ---- </para> <para> ! Every non-holdable open cursor is implicitly closed when a ! transaction is terminated by <command>COMMIT</command> or ! <command>ROLLBACK</command>. Holdable cursors are implicitely ! closed if the transaction that created them aborts via ! <command>ROLLBACK</command>; if this does not happen, the holdable ! cursor remains open until an explicit <command>CLOSE</command> is ! executed, or the client disconnects. </para> </refsect1>
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings