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.html"><LINK
22
HREF="release-9-1-7.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
74
>Appendix E. Release Notes</TD
81
HREF="release-9-1-7.html"
96
>E.1. Release 9.1.8</A
109
> This release contains a variety of fixes from 9.1.7.
110
For information about new features in the 9.1 major release, see
112
HREF="release-9-1.html"
122
>E.1.1. Migration to Version 9.1.8</A
125
> A dump/restore is not required for those running 9.1.X.
128
> However, if you are upgrading from a version earlier than 9.1.6,
129
see the release notes for 9.1.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 recycling of WAL segments after changing recovery target timeline
182
> Fix missing cancellations in hot standby mode (Noah Misch, Simon Riggs)
185
> The need to cancel conflicting hot-standby queries would sometimes be
186
missed, allowing those queries to see inconsistent data.
191
> Prevent recovery pause feature from pausing before users can connect
197
> Fix SQL grammar to allow subscripting or field selection from a
198
sub-SELECT result (Tom Lane)
203
> Fix performance problems with autovacuum truncation in busy workloads
207
> Truncation of empty pages at the end of a table requires exclusive
208
lock, but autovacuum was coded to fail (and release the table lock)
209
when there are conflicting lock requests. Under load, it is easily
210
possible that truncation would never occur, resulting in table bloat.
211
Fix by performing a partial truncation, releasing the lock, then
212
attempting to re-acquire the lock and continue. This fix also greatly
213
reduces the average time before autovacuum releases the lock after a
214
conflicting request arrives.
219
> Protect against race conditions when scanning
223
> (Stephen Frost, Tom Lane)
233
misbehave if there were concurrent updates of
245
> from trying to drop whole databases or
246
tablespaces (Álvaro Herrera)
249
> For safety, ownership of these objects must be reassigned, not dropped.
255
HREF="runtime-config-client.html#GUC-VACUUM-FREEZE-TABLE-AGE"
258
>vacuum_freeze_table_age</TT
261
implementation (Andres Freund)
264
> The main consequence of this mistake is that lowering <A
265
HREF="runtime-config-client.html#GUC-VACUUM-FREEZE-MIN-AGE"
268
>vacuum_freeze_min_age</TT
271
would cause full-table vacuuming scans to occur much more frequently
277
> Prevent misbehavior when a <TT
284
is parse-analyzed twice (Andres Freund, Tom Lane)
287
> This mistake could be user-visible in contexts such as
290
>CREATE TABLE LIKE INCLUDING INDEXES</TT
296
> Improve defenses against integer overflow in hashtable sizing
297
calculations (Jeff Davis)
302
> Fix failure to ignore leftover temporary tables after a server crash
308
> Reject out-of-range dates in <CODE
318
>pg_extension_config_dump()</CODE
320
extension-update cases properly (Tom Lane)
323
> This function will now replace any existing entry for the target
324
table, making it usable in extension update scripts.
329
> Fix PL/Python's handling of functions used as triggers on multiple
330
tables (Andres Freund)
335
> Ensure that non-ASCII prompt strings are translated to the correct
336
code page on Windows (Alexander Law, Noah Misch)
339
> This bug affected <SPAN
342
> and some other client programs.
347
> Fix possible crash in <SPAN
354
when not connected to a database (Meng Qingzhong)
359
> Fix possible error if a relation file is removed while
363
> is running (Heikki Linnakangas)
371
> exclude data of unlogged tables when
372
running on a hot-standby server (Magnus Hagander)
375
> This would fail anyway because the data is not available on the standby
376
server, so it seems most convenient to assume
379
>--no-unlogged-table-data</TT
388
> to deal with invalid indexes safely
394
> Fix one-byte buffer overrun in <SPAN
404
> This ancient function is not used anywhere by
408
> itself, but it might still be used by some
417
> use translated messages properly
423
> Properly install <SPAN
430
> libraries on MSVC (Jiang Guiqing)
435
> Include our version of <CODE
442
> if it's not provided by the system
448
> Rearrange configure's tests for supplied functions so it is not
449
fooled by bogus exports from libedit/libreadline (Christoph Berg)
454
> Ensure Windows build number increases over time (Magnus Hagander)
462
> build executables with the right
466
> suffix when cross-compiling for Windows
472
> Add new timezone abbreviation <TT
478
> This is now used in some eastern-European time zones.
489
SUMMARY="Footer navigation table"
518
HREF="release-9-1-7.html"
b'\\ No newline at end of file'