<!-- doc/src/sgml/release-8.2.sgml -->

<!-- See header comment in release.sgml about typical markup -->

<sect1 id="release-8-2-22">

<title>Release 8.2.22</title>

<note>

<title>Release Date</title>

<simpara>2011-09-26</simpara>

</note>

<para>

This release contains a variety of fixes from 8.2.21.

For information about new features in the 8.2 major release, see

<xref linkend="release-8-2">.

</para>

<para>

The <productname>PostgreSQL</> community will stop releasing updates

for the 8.2.X release series in December 2011.

Users are encouraged to update to a newer release branch soon.

</para>

<sect2>

<title>Migration to Version 8.2.22</title>

<para>

A dump/restore is not required for those running 8.2.X.

However, if you are upgrading from a version earlier than 8.2.14,

see the release notes for 8.2.14.

</para>

</sect2>

<sect2>

<title>Changes</title>

<itemizedlist>

<listitem>

<para>

Fix multiple bugs in GiST index page split processing (Heikki

Linnakangas)

</para>

<para>

The probability of occurrence was low, but these could lead to index

corruption.

</para>

</listitem>

<listitem>

<para>

Avoid possibly accessing off the end of memory in <command>ANALYZE</>

(Noah Misch)

</para>

<para>

This fixes a very-low-probability server crash scenario.

</para>

</listitem>

<listitem>

<para>

Fix race condition in relcache init file invalidation (Tom Lane)

</para>

<para>

There was a window wherein a new backend process could read a stale init

file but miss the inval messages that would tell it the data is stale.

The result would be bizarre failures in catalog accesses, typically

<quote>could not read block 0 in file ...</> later during startup.

</para>

</listitem>

<listitem>

<para>

Fix memory leak at end of a GiST index scan (Tom Lane)

</para>

<para>

Commands that perform many separate GiST index scans, such as

verification of a new GiST-based exclusion constraint on a table

already containing many rows, could transiently require large amounts of

memory due to this leak.

</para>

</listitem>

<listitem>

<para>

Fix performance problem when constructing a large, lossy bitmap

(Tom Lane)

</para>

</listitem>

<listitem>

<para>

Fix array- and path-creating functions to ensure padding bytes are

zeroes (Tom Lane)

</para>

<para>

This avoids some situations where the planner will think that

semantically-equal constants are not equal, resulting in poor

optimization.

</para>

</listitem>

<listitem>

<para>

Work around gcc 4.6.0 bug that breaks WAL replay (Tom Lane)

</para>

<para>

This could lead to loss of committed transactions after a server crash.

</para>

</listitem>

<listitem>

<para>

Fix dump bug for <literal>VALUES</> in a view (Tom Lane)

</para>

</listitem>

<listitem>

<para>

Disallow <literal>SELECT FOR UPDATE/SHARE</> on sequences (Tom Lane)

</para>

<para>

This operation doesn't work as expected and can lead to failures.

</para>

</listitem>

<listitem>

<para>

Defend against integer overflow when computing size of a hash table (Tom

Lane)

</para>

</listitem>

<listitem>

<para>

Fix portability bugs in use of credentials control messages for

<quote>peer</> authentication (Tom Lane)

</para>

</listitem>

<listitem>

<para>

Fix typo in <function>pg_srand48</> seed initialization (Andres Freund)

</para>

<para>

This led to failure to use all bits of the provided seed. This function

is not used on most platforms (only those without <function>srandom</>),

and the potential security exposure from a less-random-than-expected

seed seems minimal in any case.

</para>

</listitem>

<listitem>

<para>

Avoid integer overflow when the sum of <literal>LIMIT</> and

<literal>OFFSET</> values exceeds 2^63 (Heikki Linnakangas)

</para>

</listitem>

<listitem>

<para>

Add overflow checks to <type>int4</> and <type>int8</> versions of

<function>generate_series()</> (Robert Haas)

</para>

</listitem>

<listitem>

<para>

Fix trailing-zero removal in <function>to_char()</> (Marti Raudsepp)

</para>

<para>

In a format with <literal>FM</> and no digit positions

after the decimal point, zeroes to the left of the decimal point could

be removed incorrectly.

</para>

</listitem>

<listitem>

<para>

Fix <function>pg_size_pretty()</> to avoid overflow for inputs close to

2^63 (Tom Lane)

</para>

</listitem>

<listitem>

<para>

Fix <application>psql</>'s counting of script file line numbers during

<literal>COPY</> from a different file (Tom Lane)

</para>

</listitem>

<listitem>

<para>

Fix <application>pg_restore</>'s direct-to-database mode for

<varname>standard_conforming_strings</> (Tom Lane)

</para>

<para>

<application>pg_restore</> could emit incorrect commands when restoring

directly to a database server from an archive file that had been made

with <varname>standard_conforming_strings</> set to <literal>on</>.

</para>

</listitem>

<listitem>

<para>

Fix write-past-buffer-end and memory leak in <application>libpq</>'s

LDAP service lookup code (Albe Laurenz)

</para>

</listitem>

<listitem>

<para>

In <application>libpq</>, avoid failures when using nonblocking I/O

and an SSL connection (Martin Pihlak, Tom Lane)

</para>

</listitem>

<listitem>

<para>

Improve libpq's handling of failures during connection startup

(Tom Lane)

</para>

<para>

In particular, the response to a server report of <function>fork()</>

failure during SSL connection startup is now saner.

</para>

</listitem>

<listitem>

<para>

Make <application>ecpglib</> write <type>double</> values with 15 digits

precision (Akira Kurosawa)

</para>

</listitem>

<listitem>

<para>

Apply upstream fix for blowfish signed-character bug (CVE-2011-2483)

(Tom Lane)

</para>

<para>

<filename>contrib/pg_crypto</>'s blowfish encryption code could give

wrong results on platforms where char is signed (which is most),

leading to encrypted passwords being weaker than they should be.

</para>

</listitem>

<listitem>

<para>

Fix memory leak in <filename>contrib/seg</> (Heikki Linnakangas)

</para>

</listitem>

<listitem>

<para>

Fix <function>pgstatindex()</> to give consistent results for empty

indexes (Tom Lane)

</para>

</listitem>

<listitem>

<para>

Allow building with perl 5.14 (Alex Hunsaker)

</para>

</listitem>

<listitem>

<para>

Update configure script's method for probing existence of system

functions (Tom Lane)

</para>

<para>

The version of autoconf we used in 8.3 and 8.2 could be fooled by

compilers that perform link-time optimization.

</para>

</listitem>

<listitem>

<para>

Fix assorted issues with build and install file paths containing spaces

(Tom Lane)

</para>

</listitem>

<listitem>

<para>

Update time zone data files to <application>tzdata</> release 2011i

for DST law changes in Canada, Egypt, Russia, Samoa, and South Sudan.

</para>

</listitem>

</itemizedlist>

</sect2>

</sect1>

<sect1 id="release-8-2-21">

<title>Release 8.2.21</title>

</para>

<para>

This fix prevents a PANIC if a <literal>VACUUM FULL</> iscancelled

This fix prevents a PANIC if a <literal>VACUUM FULL</> iscanceled

after it's already committed its tuple movements, as well as transient

errors if a plain <literal>VACUUM</> is interrupted after having

truncated the table.