Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

E.20. Release 7.4.11

Release date: 2006-01-09

This release contains a variety of fixes from 7.4.10.

E.20.1. Migration to version 7.4.11

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 the release notes for 7.4.8. Also, you might need to REINDEX indexes on textual columns after updating, if you are affected by the locale or plperl issues described below.

E.20.2. Changes

  • Fix for protocol-level Describe messages issued outside a transaction or in a failed transaction (Tom)

  • Fix character string comparison for locales that consider different character combinations as equal, such as Hungarian (Tom)

    This might require REINDEX to fix existing indexes on textual columns.

  • Set locale environment variables during postmaster startup to ensure that plperl won't change the locale later

    This fixes a problem that occurred if the postmaster was started with environment variables specifying a different locale than what initdb had been told. Under these conditions, any use of plperl was likely to lead to corrupt indexes. You may need REINDEX to fix existing indexes on textual columns if this has happened to you.

  • Fix longstanding bug in strpos() and regular expression handling in certain rarely used Asian multi-byte character sets (Tatsuo)

  • Fix bug in /contrib/pgcrypto gen_salt, which caused it not to use all available salt space for MD5 and XDES algorithms (Marko Kreen, Solar Designer)

    Salts for Blowfish and standard DES are unaffected.

  • Fix /contrib/dblink to throw an error, rather than crashing, when the number of columns specified is different from what's actually returned by the query (Joe)


 
 
  Published courtesy of The PostgreSQL Global Development Group Design by Interspire