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

Reply via email to