| Server IP : 103.119.228.120 / Your IP : 18.117.71.239 Web Server : Apache System : Linux v8.techscape8.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : nobody ( 99) PHP Version : 5.6.40 Disable Function : shell_exec,symlink,system,exec,proc_get_status,proc_nice,proc_terminate,define_syslog_variables,syslog,openlog,closelog,escapeshellcmd,passthru,ocinum cols,ini_alter,leak,listen,chgrp,apache_note,apache_setenv,debugger_on,debugger_off,ftp_exec,dl,dll,myshellexec,proc_open,socket_bind,proc_close,escapeshellarg,parse_ini_filepopen,fpassthru,exec,passthru,escapeshellarg,escapeshellcmd,proc_close,proc_open,ini_alter,popen,show_source,proc_nice,proc_terminate,proc_get_status,proc_close,pfsockopen,leak,apache_child_terminate,posix_kill,posix_mkfifo,posix_setpgid,posix_setsid,posix_setuid,dl,symlink,shell_exec,system,dl,passthru,escapeshellarg,escapeshellcmd,myshellexec,c99_buff_prepare,c99_sess_put,fpassthru,getdisfunc,fx29exec,fx29exec2,is_windows,disp_freespace,fx29sh_getupdate,fx29_buff_prepare,fx29_sess_put,fx29shexit,fx29fsearch,fx29ftpbrutecheck,fx29sh_tools,fx29sh_about,milw0rm,imagez,sh_name,myshellexec,checkproxyhost,dosyayicek,c99_buff_prepare,c99_sess_put,c99getsource,c99sh_getupdate,c99fsearch,c99shexit,view_perms,posix_getpwuid,posix_getgrgid,posix_kill,parse_perms,parsesort,view_perms_color,set_encoder_input,ls_setcheckboxall,ls_reverse_all,rsg_read,rsg_glob,selfURL,dispsecinfo,unix2DosTime,addFile,system,get_users,view_size,DirFiles,DirFilesWide,DirPrintHTMLHeaders,GetFilesTotal,GetTitles,GetTimeTotal,GetMatchesCount,GetFileMatchesCount,GetResultFiles,fs_copy_dir,fs_copy_obj,fs_move_dir,fs_move_obj,fs_rmdir,SearchText,getmicrotime MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/doc/postgresql-9.2.24/html/ |
Upload File : |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Release 8.4.16</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.4.17"
HREF="release-8-4-17.html"><LINK
REL="NEXT"
TITLE="Release 8.4.15"
HREF="release-8-4-15.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.4.17"
HREF="release-8-4-17.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.4.15"
HREF="release-8-4-15.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="RELEASE-8-4-16"
>E.81. Release 8.4.16</A
></H1
><DIV
CLASS="FORMALPARA"
><P
><B
>Release date: </B
>2013-02-07</P
></DIV
><P
> This release contains a variety of fixes from 8.4.15.
For information about new features in the 8.4 major release, see
<A
HREF="release-8-4.html"
>Section E.97</A
>.
</P
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN125455"
>E.81.1. Migration to Version 8.4.16</A
></H2
><P
> A dump/restore is not required for those running 8.4.X.
</P
><P
> However, if you are upgrading from a version earlier than 8.4.10,
see <A
HREF="release-8-4-10.html"
>Section E.87</A
>.
</P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN125460"
>E.81.2. Changes</A
></H2
><P
></P
><UL
><LI
><P
> Prevent execution of <CODE
CLASS="FUNCTION"
>enum_recv</CODE
> from SQL (Tom Lane)
</P
><P
> The function was misdeclared, allowing a simple SQL command to crash the
server. In principle an attacker might be able to use it to examine the
contents of server memory. Our thanks to Sumit Soni (via Secunia SVCRP)
for reporting this issue. (CVE-2013-0255)
</P
></LI
><LI
><P
> Update minimum recovery point when truncating a relation file (Heikki
Linnakangas)
</P
><P
> Once data has been discarded, it's no longer safe to stop recovery at
an earlier point in the timeline.
</P
></LI
><LI
><P
> Fix SQL grammar to allow subscripting or field selection from a
sub-SELECT result (Tom Lane)
</P
></LI
><LI
><P
> Protect against race conditions when scanning
<TT
CLASS="STRUCTNAME"
>pg_tablespace</TT
> (Stephen Frost, Tom Lane)
</P
><P
> <TT
CLASS="COMMAND"
>CREATE DATABASE</TT
> and <TT
CLASS="COMMAND"
>DROP DATABASE</TT
> could
misbehave if there were concurrent updates of
<TT
CLASS="STRUCTNAME"
>pg_tablespace</TT
> entries.
</P
></LI
><LI
><P
> Prevent <TT
CLASS="COMMAND"
>DROP OWNED</TT
> from trying to drop whole databases or
tablespaces (Álvaro Herrera)
</P
><P
> For safety, ownership of these objects must be reassigned, not dropped.
</P
></LI
><LI
><P
> Fix error in <A
HREF="runtime-config-client.html#GUC-VACUUM-FREEZE-TABLE-AGE"
><TT
CLASS="VARNAME"
>vacuum_freeze_table_age</TT
></A
>
implementation (Andres Freund)
</P
><P
> In installations that have existed for more than <A
HREF="runtime-config-client.html#GUC-VACUUM-FREEZE-MIN-AGE"
><TT
CLASS="VARNAME"
>vacuum_freeze_min_age</TT
></A
>
transactions, this mistake prevented autovacuum from using partial-table
scans, so that a full-table scan would always happen instead.
</P
></LI
><LI
><P
> Prevent misbehavior when a <TT
CLASS="SYMBOL"
>RowExpr</TT
> or <TT
CLASS="SYMBOL"
>XmlExpr</TT
>
is parse-analyzed twice (Andres Freund, Tom Lane)
</P
><P
> This mistake could be user-visible in contexts such as
<TT
CLASS="LITERAL"
>CREATE TABLE LIKE INCLUDING INDEXES</TT
>.
</P
></LI
><LI
><P
> Improve defenses against integer overflow in hashtable sizing
calculations (Jeff Davis)
</P
></LI
><LI
><P
> Reject out-of-range dates in <CODE
CLASS="FUNCTION"
>to_date()</CODE
> (Hitoshi Harada)
</P
></LI
><LI
><P
> Ensure that non-ASCII prompt strings are translated to the correct
code page on Windows (Alexander Law, Noah Misch)
</P
><P
> This bug affected <SPAN
CLASS="APPLICATION"
>psql</SPAN
> and some other client programs.
</P
></LI
><LI
><P
> Fix possible crash in <SPAN
CLASS="APPLICATION"
>psql</SPAN
>'s <TT
CLASS="COMMAND"
>\?</TT
> command
when not connected to a database (Meng Qingzhong)
</P
></LI
><LI
><P
> Fix one-byte buffer overrun in <SPAN
CLASS="APPLICATION"
>libpq</SPAN
>'s
<CODE
CLASS="FUNCTION"
>PQprintTuples</CODE
> (Xi Wang)
</P
><P
> This ancient function is not used anywhere by
<SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> itself, but it might still be used by some
client code.
</P
></LI
><LI
><P
> Make <SPAN
CLASS="APPLICATION"
>ecpglib</SPAN
> use translated messages properly
(Chen Huajun)
</P
></LI
><LI
><P
> Properly install <SPAN
CLASS="APPLICATION"
>ecpg_compat</SPAN
> and
<SPAN
CLASS="APPLICATION"
>pgtypes</SPAN
> libraries on MSVC (Jiang Guiqing)
</P
></LI
><LI
><P
> Rearrange configure's tests for supplied functions so it is not
fooled by bogus exports from libedit/libreadline (Christoph Berg)
</P
></LI
><LI
><P
> Ensure Windows build number increases over time (Magnus Hagander)
</P
></LI
><LI
><P
> Make <SPAN
CLASS="APPLICATION"
>pgxs</SPAN
> build executables with the right
<TT
CLASS="LITERAL"
>.exe</TT
> suffix when cross-compiling for Windows
(Zoltan Boszormenyi)
</P
></LI
><LI
><P
> Add new timezone abbreviation <TT
CLASS="LITERAL"
>FET</TT
> (Tom Lane)
</P
><P
> This is now used in some eastern-European time zones.
</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-4-17.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-4-15.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Release 8.4.17</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.4.15</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>