|
16 | 16 | Major enhancements include: |
17 | 17 | </para> |
18 | 18 |
|
19 | | - <!-- This list duplicates items below, but without authors or details--> |
20 | | - |
21 | | - <para> |
22 | | - ADD HERE ... |
23 | | - </para> |
| 19 | + <!-- This list duplicates items below, but without authors or details--> |
| 20 | + |
| 21 | + <itemizedlist> |
| 22 | + |
| 23 | + <listitem> |
| 24 | + <para> |
| 25 | + Add <link linkend="SQL-CREATEMATERIALIZEDVIEW">materialized |
| 26 | + views</link> |
| 27 | + </para> |
| 28 | + </listitem> |
| 29 | + |
| 30 | + <listitem> |
| 31 | + <para> |
| 32 | + Make simple views <link |
| 33 | + linkend="SQL-CREATEVIEW-updatable-views">auto-updatable</link> |
| 34 | + </para> |
| 35 | + </listitem> |
| 36 | + |
| 37 | + <listitem> |
| 38 | + <para> |
| 39 | + Many <type>JSON</> improvements, including the addition of <link |
| 40 | + linkend="functions-json">operators and functions</link> to extract |
| 41 | + values from <type>JSON</> data strings |
| 42 | + </para> |
| 43 | + </listitem> |
| 44 | + |
| 45 | + <listitem> |
| 46 | + <para> |
| 47 | + Implement <acronym>SQL</>-standard <link |
| 48 | + linkend="queries-lateral"><literal>LATERAL</></link> option for |
| 49 | + <literal>FROM</>-clause subqueries and function calls |
| 50 | + </para> |
| 51 | + </listitem> |
| 52 | + |
| 53 | + <listitem> |
| 54 | + <para> |
| 55 | + Allow <link linkend="SQL-CREATEFOREIGNDATAWRAPPER">foreign data |
| 56 | + wrappers</link> to support writes (inserts/updates/deletes) on foreign |
| 57 | + tables |
| 58 | + </para> |
| 59 | + </listitem> |
| 60 | + |
| 61 | + <listitem> |
| 62 | + <para> |
| 63 | + Add a <productname>Postgres</> <link linkend="postgres-fdw">foreign |
| 64 | + data wrapper</link> contrib module (Shigeru Hanada) |
| 65 | + </para> |
| 66 | + </listitem> |
| 67 | + |
| 68 | + <listitem> |
| 69 | + <para> |
| 70 | + Add support for <link linkend="event-triggers">event triggers</link> |
| 71 | + </para> |
| 72 | + </listitem> |
| 73 | + |
| 74 | + <listitem> |
| 75 | + <para> |
| 76 | + Add optional ability to <link |
| 77 | + linkend="app-initdb-data-checksums">checksum</link> data pages and |
| 78 | + report corruption |
| 79 | + </para> |
| 80 | + </listitem> |
| 81 | + |
| 82 | + <listitem> |
| 83 | + <para> |
| 84 | + Allow a streaming replication standby to <link |
| 85 | + linkend="protocol-replication">follow a timeline switch</link>, |
| 86 | + and faster failover |
| 87 | + </para> |
| 88 | + </listitem> |
| 89 | + |
| 90 | + <listitem> |
| 91 | + <para> |
| 92 | + Dramatically reduce System V <link linkend="sysvipc">shared |
| 93 | + memory</link> requirements |
| 94 | + </para> |
| 95 | + </listitem> |
| 96 | + |
| 97 | + <listitem> |
| 98 | + <para> |
| 99 | + Prevent non-key-field row updates from locking foreign key rows |
| 100 | + </para> |
| 101 | + </listitem> |
| 102 | + |
| 103 | + </itemizedlist> |
24 | 104 |
|
25 | 105 | <para> |
26 | 106 | The above items are explained in more detail in the sections below. |
|
1130 | 1210 | </para> |
1131 | 1211 | </listitem> |
1132 | 1212 |
|
| 1213 | + <listitem> |
| 1214 | + <para> |
| 1215 | + Allow PL/pgSQL to access <link |
| 1216 | + linkend="libpq-pqresulterrorfield">constraint violation |
| 1217 | + details</link> as separate fields (Pavel Stehule) |
| 1218 | + </para> |
| 1219 | + </listitem> |
| 1220 | + |
1133 | 1221 | <listitem> |
1134 | 1222 | <para> |
1135 | 1223 | Allow PL/pgSQL to access the number of rows processed by |
|
1143 | 1231 | </para> |
1144 | 1232 | </listitem> |
1145 | 1233 |
|
1146 | | - <listitem> |
1147 | | - <para> |
1148 | | - Allow PL/pgSQL to access <link |
1149 | | - linkend="libpq-pqresulterrorfield">constraint violation |
1150 | | - details</link> as separate fields (Pavel Stehule) |
1151 | | - </para> |
1152 | | - </listitem> |
1153 | | - |
1154 | 1234 | <listitem> |
1155 | 1235 | <para> |
1156 | 1236 | Allow greater flexibility in where keywords can be used in PL/pgSQL (Tom Lane) |
|
1270 | 1350 |
|
1271 | 1351 | <listitem> |
1272 | 1352 | <para> |
1273 | | - Allow the <application>psql</> <option>--single-transaction</> mode to work when |
1274 | | - reading from standard input (Fabien Coelho, Robert Haas) |
| 1353 | + Allow the <application>psql</> <option>--single-transaction</> |
| 1354 | + mode to work when reading from standard input (Fabien Coelho, |
| 1355 | + Robert Haas) |
1275 | 1356 | </para> |
1276 | 1357 |
|
1277 | 1358 | <para> |
|