1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1.8 Documentation"
13
HREF="index.html"><LINK
16
HREF="release.html"><LINK
19
HREF="release-9-1.html"><LINK
21
TITLE="Release 9.0.11"
22
HREF="release-9-0-11.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2013-02-04T21:38:53"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1.8 Documentation</A
57
HREF="release-9-1.html"
74
>Appendix E. Release Notes</TD
80
TITLE="Release 9.0.11"
81
HREF="release-9-0-11.html"
96
>E.10. Release 9.0.12</A
109
> This release contains a variety of fixes from 9.0.11.
110
For information about new features in the 9.0 major release, see
112
HREF="release-9-0.html"
122
>E.10.1. Migration to Version 9.0.12</A
125
> A dump/restore is not required for those running 9.0.X.
128
> However, if you are upgrading from a version earlier than 9.0.6,
129
see the release notes for 9.0.6.
145
> Prevent execution of <CODE
148
> from SQL (Tom Lane)
151
> The function was misdeclared, allowing a simple SQL command to crash the
152
server. In principle an attacker might be able to use it to examine the
153
contents of server memory. Our thanks to Sumit Soni (via Secunia SVCRP)
154
for reporting this issue. (CVE-2013-0255)
159
> Fix multiple problems in detection of when a consistent database
160
state has been reached during WAL replay (Fujii Masao, Heikki
161
Linnakangas, Simon Riggs, Andres Freund)
166
> Update minimum recovery point when truncating a relation file (Heikki
170
> Once data has been discarded, it's no longer safe to stop recovery at
171
an earlier point in the timeline.
176
> Fix missing cancellations in hot standby mode (Noah Misch, Simon Riggs)
179
> The need to cancel conflicting hot-standby queries would sometimes be
180
missed, allowing those queries to see inconsistent data.
185
> Fix SQL grammar to allow subscripting or field selection from a
186
sub-SELECT result (Tom Lane)
191
> Fix performance problems with autovacuum truncation in busy workloads
195
> Truncation of empty pages at the end of a table requires exclusive
196
lock, but autovacuum was coded to fail (and release the table lock)
197
when there are conflicting lock requests. Under load, it is easily
198
possible that truncation would never occur, resulting in table bloat.
199
Fix by performing a partial truncation, releasing the lock, then
200
attempting to re-acquire the lock and continue. This fix also greatly
201
reduces the average time before autovacuum releases the lock after a
202
conflicting request arrives.
207
> Protect against race conditions when scanning
211
> (Stephen Frost, Tom Lane)
221
misbehave if there were concurrent updates of
233
> from trying to drop whole databases or
234
tablespaces (Álvaro Herrera)
237
> For safety, ownership of these objects must be reassigned, not dropped.
243
HREF="runtime-config-client.html#GUC-VACUUM-FREEZE-TABLE-AGE"
246
>vacuum_freeze_table_age</TT
249
implementation (Andres Freund)
252
> The main consequence of this mistake is that lowering <A
253
HREF="runtime-config-client.html#GUC-VACUUM-FREEZE-MIN-AGE"
256
>vacuum_freeze_min_age</TT
259
would cause full-table vacuuming scans to occur much more frequently
265
> Prevent misbehavior when a <TT
272
is parse-analyzed twice (Andres Freund, Tom Lane)
275
> This mistake could be user-visible in contexts such as
278
>CREATE TABLE LIKE INCLUDING INDEXES</TT
284
> Improve defenses against integer overflow in hashtable sizing
285
calculations (Jeff Davis)
290
> Reject out-of-range dates in <CODE
298
> Ensure that non-ASCII prompt strings are translated to the correct
299
code page on Windows (Alexander Law, Noah Misch)
302
> This bug affected <SPAN
305
> and some other client programs.
310
> Fix possible crash in <SPAN
317
when not connected to a database (Meng Qingzhong)
325
> to deal with invalid indexes safely
331
> Fix one-byte buffer overrun in <SPAN
341
> This ancient function is not used anywhere by
345
> itself, but it might still be used by some
354
> use translated messages properly
360
> Properly install <SPAN
367
> libraries on MSVC (Jiang Guiqing)
372
> Include our version of <CODE
379
> if it's not provided by the system
385
> Rearrange configure's tests for supplied functions so it is not
386
fooled by bogus exports from libedit/libreadline (Christoph Berg)
391
> Ensure Windows build number increases over time (Magnus Hagander)
399
> build executables with the right
403
> suffix when cross-compiling for Windows
409
> Add new timezone abbreviation <TT
415
> This is now used in some eastern-European time zones.
426
SUMMARY="Footer navigation table"
437
HREF="release-9-1.html"
455
HREF="release-9-0-11.html"
b'\\ No newline at end of file'