|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/ref/close.sgml,v 1.14 2003/04/15 13:25:08 petere Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/close.sgml,v 1.15 2003/08/17 04:46:00 momjian Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -31,9 +31,13 @@ CLOSE <replaceable class="PARAMETER">cursor</replaceable> |
31 | 31 | </para> |
32 | 32 |
|
33 | 33 | <para> |
34 | | - Every open cursor is implicitly closed when a transaction is |
35 | | - terminated by <command>COMMIT</command> or |
36 | | - <command>ROLLBACK</command>. |
| 34 | + Every non-holdable open cursor is implicitly closed when a |
| 35 | + transaction is terminated by <command>COMMIT</command> or |
| 36 | + <command>ROLLBACK</command>. Holdable cursors are implicitely |
| 37 | + closed if the transaction that created them aborts via |
| 38 | + <command>ROLLBACK</command>; if this does not happen, the holdable |
| 39 | + cursor remains open until an explicit <command>CLOSE</command> is |
| 40 | + executed, or the client disconnects. |
37 | 41 | </para> |
38 | 42 | </refsect1> |
39 | 43 |
|
|