E.293. Release 7.4.9
Release date: 2005-10-04
This release contains a variety of fixes from 7.4.8. For information about new features in the 7.4 major release, see Section E.302.
E.293.1. Migration to Version 7.4.9
A dump/restore is not required for those running 7.4.X. However, if you are upgrading from a version earlier than 7.4.8, see Section E.294.
E.293.2. Changes
Fix error that allowed
VACUUMto removectidchains too soon, and add more checking in code that followsctidlinksThis fixes a long-standing problem that could cause crashes in very rare circumstances.
Fix
CHAR()to properly pad spaces to the specified length when using a multiple-byte character set (Yoshiyuki Asaba)In prior releases, the padding of
CHAR()was incorrect because it only padded to the specified number of bytes without considering how many characters were stored.Fix the sense of the test for read-only transaction in
COPYThe code formerly prohibited
COPY TO, where it should prohibitCOPY FROM.Fix planning problem with outer-join ON clauses that reference only the inner-side relation
Further fixes for
x FULL JOIN y ON truecorner casesMake
array_inandarray_recvmore paranoid about validating their OID parameterFix missing rows in queries like
UPDATE a=... WHERE a...with GiST index on columnaImprove robustness of datetime parsing
Improve checking for partially-written WAL pages
Improve robustness of signal handling when SSL is enabled
Don't try to open more than
max_files_per_processfiles during postmaster startupVarious memory leakage fixes
Various portability improvements
Fix PL/pgSQL to handle
var := varcorrectly when the variable is of pass-by-reference typeUpdate
contrib/tsearch2to use current Snowball code

