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.1beta1 Documentation"
13
HREF="index.html"><LINK
16
HREF="release.html"><LINK
18
TITLE="Release 8.2.19"
19
HREF="release-8-2-19.html"><LINK
21
TITLE="Release 8.2.17"
22
HREF="release-8-2-17.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
56
TITLE="Release 8.2.19"
57
HREF="release-8-2-19.html"
74
>Appendix E. Release Notes</TD
89
TITLE="Release 8.2.17"
90
HREF="release-8-2-17.html"
104
NAME="RELEASE-8-2-18"
105
>E.35. Release 8.2.18</A
118
> This release contains a variety of fixes from 8.2.17.
119
For information about new features in the 8.2 major release, see
121
HREF="release-8-2.html"
131
>E.35.1. Migration to Version 8.2.18</A
134
> A dump/restore is not required for those running 8.2.X.
135
However, if you are upgrading from a version earlier than 8.2.14,
136
see the release notes for 8.2.14.
152
> Use a separate interpreter for each calling SQL userid in PL/Perl and
156
> This change prevents security problems that can be caused by subverting
157
Perl or Tcl code that will be executed later in the same session under
158
another SQL user identity (for example, within a <TT
162
> function). Most scripting languages offer numerous ways that
163
that might be done, such as redefining standard functions or operators
164
called by the target function. Without this change, any SQL user with
165
Perl or Tcl language usage rights can do essentially anything with the
166
SQL privileges of the target function's owner.
169
> The cost of this change is that intentional communication among Perl
170
and Tcl functions becomes more difficult. To provide an escape hatch,
171
PL/PerlU and PL/TclU functions continue to use only one interpreter
172
per session. This is not considered a security issue since all such
173
functions execute at the trust level of a database superuser already.
176
> It is likely that third-party procedural languages that claim to offer
177
trusted execution have similar security issues. We advise contacting
178
the authors of any PL you are depending on for security-critical
182
> Our thanks to Tim Bunce for pointing out this issue (CVE-2010-3433).
187
> Prevent possible crashes in <CODE
191
it from being called with an argument that is not one of the system
192
catalog columns it's intended to be used with
193
(Heikki Linnakangas, Tom Lane)
198
> Fix Windows shared-memory allocation code
199
(Tsutomu Yamada, Magnus Hagander)
202
> This bug led to the often-reported <SPAN
204
>"could not reattach to shared
206
> error message. This is a back-patch of a fix that was
207
applied to newer branches some time ago.
212
> Treat exit code 128 (<TT
214
>ERROR_WAIT_NO_CHILDREN</TT
216
Windows (Magnus Hagander)
219
> Under high load, Windows processes will sometimes fail at startup with
220
this error code. Formerly the postmaster treated this as a panic
221
condition and restarted the whole database, but that seems to be
227
> Fix possible duplicate scans of <TT
238
>"cannot handle unplanned sub-select"</SPAN
242
> This occurred when a sub-select contains a join alias reference that
243
expands into an expression containing another sub-select.
248
> Reduce PANIC to ERROR in some occasionally-reported btree failure cases,
249
and provide additional detail in the resulting error messages
253
> This should improve the system's robustness with corrupted indexes.
258
> Prevent show_session_authorization() from crashing within autovacuum
264
> Defend against functions returning setof record where not all the
265
returned rows are actually of the same rowtype (Tom Lane)
270
> Fix possible failure when hashing a pass-by-reference function result
276
> Take care to fsync the contents of lockfiles (both
280
> and the socket lockfile) while writing them
284
> This omission could result in corrupted lockfile contents if the
285
machine crashes shortly after postmaster start. That could in turn
286
prevent subsequent attempts to start the postmaster from succeeding,
287
until the lockfile is manually removed.
292
> Avoid recursion while assigning XIDs to heavily-nested
293
subtransactions (Andres Freund, Robert Haas)
296
> The original coding could result in a crash if there was limited
309
which could produce junk early in backend startup (Tom Lane)
314
> Fix possible data corruption in <TT
318
> when archiving is enabled (Jeff Davis)
328
>ALTER DATABASE ... SET
330
> to be interrupted by query-cancel (Guillaume Lelarge)
335
> In PL/Python, defend against null pointer results from
338
>PyCObject_AsVoidPtr</CODE
341
>PyCObject_FromVoidPtr</CODE
351
>'s handling of tables containing
352
dropped columns (Tom Lane)
357
> Fix connection leak after <SPAN
359
>"duplicate connection name"</SPAN
372
> to handle connection names longer than
373
62 bytes correctly (Itagaki Takahiro)
380
>hstore(text, text)</CODE
388
> This function is the recommended substitute for the now-deprecated
392
> operator. It was back-patched so that future-proofed
393
code can be used with older server versions. Note that the patch will
394
be effective only after <TT
398
reinstalled in a particular database. Users might prefer to execute
402
> command by hand, instead.
407
> Update build infrastructure and documentation to reflect the source code
408
repository's move from CVS to Git (Magnus Hagander and others)
413
> Update time zone data files to <SPAN
417
for DST law changes in Egypt and Palestine; also historical corrections
421
> This change also adds new names for two Micronesian timezones:
422
Pacific/Chuuk is now preferred over Pacific/Truk (and the preferred
423
abbreviation is CHUT not TRUT) and Pacific/Pohnpei is preferred over
429
> Make Windows' <SPAN
431
>"N. Central Asia Standard Time"</SPAN
433
Asia/Novosibirsk, not Asia/Almaty (Magnus Hagander)
436
> Microsoft changed the DST behavior of this zone in the timezone update
437
from KB976098. Asia/Novosibirsk is a better match to its new behavior.
448
SUMMARY="Footer navigation table"
459
HREF="release-8-2-19.html"
477
HREF="release-8-2-17.html"
b'\\ No newline at end of file'