|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.242 2003/11/15 20:01:11 tgl Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.243 2003/11/16 03:23:48 tgl Exp $ |
3 | 3 | --> |
4 | 4 |
|
5 | 5 | <appendix id="release"> |
@@ -1059,9 +1059,10 @@ $Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.242 2003/11/15 20:01:11 tg |
1059 | 1059 | <para>Allow cursors outside transactions using <literal>WITH HOLD</literal> (Neil)</para> |
1060 | 1060 | <para> |
1061 | 1061 | In previous releases, cursors were removed at the end of the |
1062 | | - transaction. Using <literal>WITH HOLD</literal>, the current |
1063 | | - release allows cursors to remain readable after the creating |
1064 | | - transaction. |
| 1062 | + transaction that created them. Cursors can now be created with |
| 1063 | + the <literal>WITH HOLD</literal> option, which allows them to |
| 1064 | + continue to be accessed after the creating transaction has |
| 1065 | + committed. |
1065 | 1066 | </para> |
1066 | 1067 | </listitem> |
1067 | 1068 |
|
@@ -1091,16 +1092,18 @@ $Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.242 2003/11/15 20:01:11 tg |
1091 | 1092 | <para>Properly handle <literal>SCROLL</literal> with cursors, or |
1092 | 1093 | report an error (Neil)</para> |
1093 | 1094 | <para> |
1094 | | - Certain cursors can not be fetched backwards optimally. By |
1095 | | - specifying <literal>SCROLL</literal>, extra work will be |
1096 | | - performed to guarantee that the cursor can be fetched in reverse |
1097 | | - or random order. |
| 1095 | + Allowing random access (both forward and backward scrolling) to |
| 1096 | + some kinds of queries cannot be done without some additional |
| 1097 | + work. If <literal>SCROLL</literal> is specified when the cursor |
| 1098 | + is created, this additional work will be performed. Furthermore, |
| 1099 | + if the cursor has been created with <literal>NO SCROLL</literal>, |
| 1100 | + no random access is allowed. |
1098 | 1101 | </para> |
1099 | 1102 | </listitem> |
1100 | 1103 |
|
1101 | 1104 | <listitem> |
1102 | 1105 | <para> |
1103 | | - Implement SQL-compatibleoption <literal>FIRST</>, |
| 1106 | + Implement SQL-compatibleoptions <literal>FIRST</>, |
1104 | 1107 | <literal>LAST</>, <literal>ABSOLUTE <replaceable>n</></>, |
1105 | 1108 | <literal>RELATIVE <replaceable>n</></> for |
1106 | 1109 | <command>FETCH</command> and <command>MOVE</command> (Tom) |
@@ -1151,7 +1154,8 @@ $Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.242 2003/11/15 20:01:11 tg |
1151 | 1154 | <para>Make <command>TRUNCATE</command> transaction-safe (Rod)</para> |
1152 | 1155 | <para> |
1153 | 1156 | <command>TRUNCATE</command> can now be used inside a |
1154 | | - transaction, and rolled back if the transaction aborts. |
| 1157 | + transaction. If the transaction aborts, the changes made by the |
| 1158 | + <command>TRUNCATE</command> are automatically rolled back. |
1155 | 1159 | </para> |
1156 | 1160 | </listitem> |
1157 | 1161 |
|
|