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
