D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
proc
/
self
/
root
/
opt
/
alt
/
postgresql11
/
usr
/
share
/
doc
/
alt-postgresql11-9.2.24
/
html
/
Filename :
release-8-0-5.html
back
Copy
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >Release 8.0.5</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 9.2.24 Documentation" HREF="index.html"><LINK REL="UP" TITLE="Release Notes" HREF="release.html"><LINK REL="PREVIOUS" TITLE="Release 8.0.6" HREF="release-8-0-6.html"><LINK REL="NEXT" TITLE="Release 8.0.4" HREF="release-8-0-4.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="stylesheet.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" CONTENT="2017-11-06T22:43:11"></HEAD ><BODY CLASS="SECT1" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="5" ALIGN="center" VALIGN="bottom" ><A HREF="index.html" >PostgreSQL 9.2.24 Documentation</A ></TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A TITLE="Release 8.0.6" HREF="release-8-0-6.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="release.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="60%" ALIGN="center" VALIGN="bottom" >Appendix E. Release Notes</TD ><TD WIDTH="20%" ALIGN="right" VALIGN="top" ><A TITLE="Release 8.0.4" HREF="release-8-0-4.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="RELEASE-8-0-5" >E.191. Release 8.0.5</A ></H1 ><DIV CLASS="FORMALPARA" ><P ><B >Release date: </B >2005-12-12</P ></DIV ><P > This release contains a variety of fixes from 8.0.4. For information about new features in the 8.0 major release, see <A HREF="release-8-0.html" >Section E.196</A >. </P ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="AEN139006" >E.191.1. Migration to Version 8.0.5</A ></H2 ><P > A dump/restore is not required for those running 8.0.X. However, if you are upgrading from a version earlier than 8.0.3, see <A HREF="release-8-0-3.html" >Section E.193</A >. </P ></DIV ><DIV CLASS="SECT2" ><H2 CLASS="SECT2" ><A NAME="AEN139010" >E.191.2. Changes</A ></H2 ><P ></P ><UL ><LI ><P >Fix race condition in transaction log management</P ><P >There was a narrow window in which an I/O operation could be initiated for the wrong page, leading to an Assert failure or data corruption.</P ></LI ><LI ><P >Fix bgwriter problems after recovering from errors (Tom)</P ><P >The background writer was found to leak buffer pins after write errors. While not fatal in itself, this might lead to mysterious blockages of later VACUUM commands.</P ></LI ><LI ><P >Prevent failure if client sends Bind protocol message when current transaction is already aborted</P ></LI ><LI ><P ><TT CLASS="FILENAME" >/contrib/ltree</TT > fixes (Teodor)</P ></LI ><LI ><P >AIX and HPUX compile fixes (Tom)</P ></LI ><LI ><P >Retry file reads and writes after Windows NO_SYSTEM_RESOURCES error (Qingqing Zhou)</P ></LI ><LI ><P >Fix intermittent failure when <TT CLASS="VARNAME" >log_line_prefix</TT > includes <TT CLASS="LITERAL" >%i</TT ></P ></LI ><LI ><P >Fix <SPAN CLASS="APPLICATION" >psql</SPAN > performance issue with long scripts on Windows (Merlin Moncure)</P ></LI ><LI ><P >Fix missing updates of <TT CLASS="FILENAME" >pg_group</TT > flat file</P ></LI ><LI ><P >Fix longstanding planning error for outer joins</P ><P >This bug sometimes caused a bogus error <SPAN CLASS="QUOTE" >"RIGHT JOIN is only supported with merge-joinable join conditions"</SPAN >.</P ></LI ><LI ><P >Postpone timezone initialization until after <TT CLASS="FILENAME" >postmaster.pid</TT > is created</P ><P >This avoids confusing startup scripts that expect the pid file to appear quickly.</P ></LI ><LI ><P >Prevent core dump in <SPAN CLASS="APPLICATION" >pg_autovacuum</SPAN > when a table has been dropped</P ></LI ><LI ><P >Fix problems with whole-row references (<TT CLASS="LITERAL" >foo.*</TT >) to subquery results</P ></LI ></UL ></DIV ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="release-8-0-6.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="release-8-0-4.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Release 8.0.6</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="release.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Release 8.0.4</TD ></TR ></TABLE ></DIV ></BODY ></HTML >