| Server IP : 103.119.228.120 / Your IP : 3.137.159.17 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/local/ssl/local/ssl/local/ssl/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 9.2.10</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 9.2.11"
HREF="release-9-2-11.html"><LINK
REL="NEXT"
TITLE="Release 9.2.9"
HREF="release-9-2-9.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 9.2.11"
HREF="release-9-2-11.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 9.2.9"
HREF="release-9-2-9.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="RELEASE-9-2-10"
>E.15. Release 9.2.10</A
></H1
><DIV
CLASS="FORMALPARA"
><P
><B
>Release date: </B
>2015-02-05</P
></DIV
><P
> This release contains a variety of fixes from 9.2.9.
For information about new features in the 9.2 major release, see
<A
HREF="release-9-2.html"
>Section E.25</A
>.
</P
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN112536"
>E.15.1. Migration to Version 9.2.10</A
></H2
><P
> A dump/restore is not required for those running 9.2.X.
</P
><P
> However, if you are a Windows user and are using the <SPAN
CLASS="QUOTE"
>"Norwegian
(Bokmål)"</SPAN
> locale, manual action is needed after the upgrade to
replace any <SPAN
CLASS="QUOTE"
>"Norwegian (Bokmål)_Norway"</SPAN
> locale names stored
in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> system catalogs with the plain-ASCII
alias <SPAN
CLASS="QUOTE"
>"Norwegian_Norway"</SPAN
>. For details see
<A
HREF="http://wiki.postgresql.org/wiki/Changes_To_Norwegian_Locale"
TARGET="_top"
>http://wiki.postgresql.org/wiki/Changes_To_Norwegian_Locale</A
>
</P
><P
> Also, if you are upgrading from a version earlier than 9.2.9,
see <A
HREF="release-9-2-9.html"
>Section E.16</A
>.
</P
></DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="AEN112547"
>E.15.2. Changes</A
></H2
><P
></P
><UL
><LI
><P
> Fix buffer overruns in <CODE
CLASS="FUNCTION"
>to_char()</CODE
>
(Bruce Momjian)
</P
><P
> When <CODE
CLASS="FUNCTION"
>to_char()</CODE
> processes a numeric formatting template
calling for a large number of digits, <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
>
would read past the end of a buffer. When processing a crafted
timestamp formatting template, <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> would write
past the end of a buffer. Either case could crash the server.
We have not ruled out the possibility of attacks that lead to
privilege escalation, though they seem unlikely.
(CVE-2015-0241)
</P
></LI
><LI
><P
> Fix buffer overrun in replacement <CODE
CLASS="FUNCTION"
>*printf()</CODE
> functions
(Tom Lane)
</P
><P
> <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> includes a replacement implementation
of <CODE
CLASS="FUNCTION"
>printf</CODE
> and related functions. This code will overrun
a stack buffer when formatting a floating point number (conversion
specifiers <TT
CLASS="LITERAL"
>e</TT
>, <TT
CLASS="LITERAL"
>E</TT
>, <TT
CLASS="LITERAL"
>f</TT
>, <TT
CLASS="LITERAL"
>F</TT
>,
<TT
CLASS="LITERAL"
>g</TT
> or <TT
CLASS="LITERAL"
>G</TT
>) with requested precision greater than
about 500. This will crash the server, and we have not ruled out the
possibility of attacks that lead to privilege escalation.
A database user can trigger such a buffer overrun through
the <CODE
CLASS="FUNCTION"
>to_char()</CODE
> SQL function. While that is the only
affected core <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> functionality, extension
modules that use printf-family functions may be at risk as well.
</P
><P
> This issue primarily affects <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> on Windows.
<SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> uses the system implementation of these
functions where adequate, which it is on other modern platforms.
(CVE-2015-0242)
</P
></LI
><LI
><P
> Fix buffer overruns in <TT
CLASS="FILENAME"
>contrib/pgcrypto</TT
>
(Marko Tiikkaja, Noah Misch)
</P
><P
> Errors in memory size tracking within the <TT
CLASS="FILENAME"
>pgcrypto</TT
>
module permitted stack buffer overruns and improper dependence on the
contents of uninitialized memory. The buffer overrun cases can
crash the server, and we have not ruled out the possibility of
attacks that lead to privilege escalation.
(CVE-2015-0243)
</P
></LI
><LI
><P
> Fix possible loss of frontend/backend protocol synchronization after
an error
(Heikki Linnakangas)
</P
><P
> If any error occurred while the server was in the middle of reading a
protocol message from the client, it could lose synchronization and
incorrectly try to interpret part of the message's data as a new
protocol message. An attacker able to submit crafted binary data
within a command parameter might succeed in injecting his own SQL
commands this way. Statement timeout and query cancellation are the
most likely sources of errors triggering this scenario. Particularly
vulnerable are applications that use a timeout and also submit
arbitrary user-crafted data as binary query parameters. Disabling
statement timeout will reduce, but not eliminate, the risk of
exploit. Our thanks to Emil Lenngren for reporting this issue.
(CVE-2015-0244)
</P
></LI
><LI
><P
> Fix information leak via constraint-violation error messages
(Stephen Frost)
</P
><P
> Some server error messages show the values of columns that violate
a constraint, such as a unique constraint. If the user does not have
<TT
CLASS="LITERAL"
>SELECT</TT
> privilege on all columns of the table, this could
mean exposing values that the user should not be able to see. Adjust
the code so that values are displayed only when they came from the SQL
command or could be selected by the user.
(CVE-2014-8161)
</P
></LI
><LI
><P
> Lock down regression testing's temporary installations on Windows
(Noah Misch)
</P
><P
> Use SSPI authentication to allow connections only from the OS user
who launched the test suite. This closes on Windows the same
vulnerability previously closed on other platforms, namely that other
users might be able to connect to the test postmaster.
(CVE-2014-0067)
</P
></LI
><LI
><P
> Cope with the Windows locale named <SPAN
CLASS="QUOTE"
>"Norwegian (Bokmål)"</SPAN
>
(Heikki Linnakangas)
</P
><P
> Non-ASCII locale names are problematic since it's not clear what
encoding they should be represented in. Map the troublesome locale
name to a plain-ASCII alias, <SPAN
CLASS="QUOTE"
>"Norwegian_Norway"</SPAN
>.
</P
></LI
><LI
><P
> Avoid possible data corruption if <TT
CLASS="COMMAND"
>ALTER DATABASE SET
TABLESPACE</TT
> is used to move a database to a new tablespace and then
shortly later move it back to its original tablespace (Tom Lane)
</P
></LI
><LI
><P
> Avoid corrupting tables when <TT
CLASS="COMMAND"
>ANALYZE</TT
> inside a transaction
is rolled back (Andres Freund, Tom Lane, Michael Paquier)
</P
><P
> If the failing transaction had earlier removed the last index, rule, or
trigger from the table, the table would be left in a corrupted state
with the relevant <TT
CLASS="STRUCTNAME"
>pg_class</TT
> flags not set though they
should be.
</P
></LI
><LI
><P
> Ensure that unlogged tables are copied correctly
during <TT
CLASS="COMMAND"
>CREATE DATABASE</TT
> or <TT
CLASS="COMMAND"
>ALTER DATABASE SET
TABLESPACE</TT
> (Pavan Deolasee, Andres Freund)
</P
></LI
><LI
><P
> Fix <TT
CLASS="COMMAND"
>DROP</TT
>'s dependency searching to correctly handle the
case where a table column is recursively visited before its table
(Petr Jelinek, Tom Lane)
</P
><P
> This case is only known to arise when an extension creates both a
datatype and a table using that datatype. The faulty code might
refuse a <TT
CLASS="COMMAND"
>DROP EXTENSION</TT
> unless <TT
CLASS="LITERAL"
>CASCADE</TT
> is
specified, which should not be required.
</P
></LI
><LI
><P
> Fix use-of-already-freed-memory problem in EvalPlanQual processing
(Tom Lane)
</P
><P
> In <TT
CLASS="LITERAL"
>READ COMMITTED</TT
> mode, queries that lock or update
recently-updated rows could crash as a result of this bug.
</P
></LI
><LI
><P
> Fix planning of <TT
CLASS="COMMAND"
>SELECT FOR UPDATE</TT
> when using a partial
index on a child table (Kyotaro Horiguchi)
</P
><P
> In <TT
CLASS="LITERAL"
>READ COMMITTED</TT
> mode, <TT
CLASS="COMMAND"
>SELECT FOR UPDATE</TT
> must
also recheck the partial index's <TT
CLASS="LITERAL"
>WHERE</TT
> condition when
rechecking a recently-updated row to see if it still satisfies the
query's <TT
CLASS="LITERAL"
>WHERE</TT
> condition. This requirement was missed if the
index belonged to an inheritance child table, so that it was possible
to incorrectly return rows that no longer satisfy the query condition.
</P
></LI
><LI
><P
> Fix corner case wherein <TT
CLASS="COMMAND"
>SELECT FOR UPDATE</TT
> could return a row
twice, and possibly miss returning other rows (Tom Lane)
</P
><P
> In <TT
CLASS="LITERAL"
>READ COMMITTED</TT
> mode, a <TT
CLASS="COMMAND"
>SELECT FOR UPDATE</TT
>
that is scanning an inheritance tree could incorrectly return a row
from a prior child table instead of the one it should return from a
later child table.
</P
></LI
><LI
><P
> Reject duplicate column names in the referenced-columns list of
a <TT
CLASS="LITERAL"
>FOREIGN KEY</TT
> declaration (David Rowley)
</P
><P
> This restriction is per SQL standard. Previously we did not reject
the case explicitly, but later on the code would fail with
bizarre-looking errors.
</P
></LI
><LI
><P
> Restore previous behavior of conversion of domains to JSON
(Tom Lane)
</P
><P
> This change causes domains over numeric and boolean to be treated
like their base types for purposes of conversion to JSON. It worked
like that before 9.3.5 and 9.2.9, but was unintentionally changed
while fixing a related problem.
</P
></LI
><LI
><P
> Fix bugs in raising a <TT
CLASS="TYPE"
>numeric</TT
> value to a large integral power
(Tom Lane)
</P
><P
> The previous code could get a wrong answer, or consume excessive
amounts of time and memory before realizing that the answer must
overflow.
</P
></LI
><LI
><P
> In <CODE
CLASS="FUNCTION"
>numeric_recv()</CODE
>, truncate away any fractional digits
that would be hidden according to the value's <TT
CLASS="LITERAL"
>dscale</TT
> field
(Tom Lane)
</P
><P
> A <TT
CLASS="TYPE"
>numeric</TT
> value's display scale (<TT
CLASS="LITERAL"
>dscale</TT
>) should
never be less than the number of nonzero fractional digits; but
apparently there's at least one broken client application that
transmits binary <TT
CLASS="TYPE"
>numeric</TT
> values in which that's true.
This leads to strange behavior since the extra digits are taken into
account by arithmetic operations even though they aren't printed.
The least risky fix seems to be to truncate away such <SPAN
CLASS="QUOTE"
>"hidden"</SPAN
>
digits on receipt, so that the value is indeed what it prints as.
</P
></LI
><LI
><P
> Fix incorrect search for shortest-first regular expression matches
(Tom Lane)
</P
><P
> Matching would often fail when the number of allowed iterations is
limited by a <TT
CLASS="LITERAL"
>?</TT
> quantifier or a bound expression.
</P
></LI
><LI
><P
> Reject out-of-range numeric timezone specifications (Tom Lane)
</P
><P
> Simple numeric timezone specifications exceeding +/- 168 hours (one
week) would be accepted, but could then cause null-pointer dereference
crashes in certain operations. There's no use-case for such large UTC
offsets, so reject them.
</P
></LI
><LI
><P
> Fix bugs in <TT
CLASS="TYPE"
>tsquery</TT
> <TT
CLASS="LITERAL"
>@></TT
> <TT
CLASS="TYPE"
>tsquery</TT
>
operator (Heikki Linnakangas)
</P
><P
> Two different terms would be considered to match if they had the same
CRC. Also, if the second operand had more terms than the first, it
would be assumed not to be contained in the first; which is wrong
since it might contain duplicate terms.
</P
></LI
><LI
><P
> Improve ispell dictionary's defenses against bad affix files (Tom Lane)
</P
></LI
><LI
><P
> Allow more than 64K phrases in a thesaurus dictionary (David Boutin)
</P
><P
> The previous coding could crash on an oversize dictionary, so this was
deemed a back-patchable bug fix rather than a feature addition.
</P
></LI
><LI
><P
> Fix namespace handling in <CODE
CLASS="FUNCTION"
>xpath()</CODE
> (Ali Akbar)
</P
><P
> Previously, the <TT
CLASS="TYPE"
>xml</TT
> value resulting from
an <CODE
CLASS="FUNCTION"
>xpath()</CODE
> call would not have namespace declarations if
the namespace declarations were attached to an ancestor element in the
input <TT
CLASS="TYPE"
>xml</TT
> value, rather than to the specific element being
returned. Propagate the ancestral declaration so that the result is
correct when considered in isolation.
</P
></LI
><LI
><P
> Ensure that whole-row variables expose nonempty column names
to functions that pay attention to column names within composite
arguments (Tom Lane)
</P
><P
> In some contexts, constructs like <TT
CLASS="LITERAL"
>row_to_json(tab.*)</TT
> may
not produce the expected column names. This is fixed properly as of
9.4; in older branches, just ensure that we produce some nonempty
name. (In some cases this will be the underlying table's column name
rather than the query-assigned alias that should theoretically be
visible.)
</P
></LI
><LI
><P
> Fix mishandling of system columns,
particularly <TT
CLASS="STRUCTFIELD"
>tableoid</TT
>, in FDW queries (Etsuro Fujita)
</P
></LI
><LI
><P
> Avoid doing <TT
CLASS="LITERAL"
><TT
CLASS="REPLACEABLE"
><I
>indexed_column</I
></TT
> = ANY
(<TT
CLASS="REPLACEABLE"
><I
>array</I
></TT
>)</TT
> as an index qualifier if that leads
to an inferior plan (Andrew Gierth)
</P
><P
> In some cases, <TT
CLASS="LITERAL"
>= ANY</TT
> conditions applied to non-first index
columns would be done as index conditions even though it would be
better to use them as simple filter conditions.
</P
></LI
><LI
><P
> Fix planner problems with nested append relations, such as inherited
tables within <TT
CLASS="LITERAL"
>UNION ALL</TT
> subqueries (Tom Lane)
</P
></LI
><LI
><P
> Fail cleanly when a GiST index tuple doesn't fit on a page, rather
than going into infinite recursion (Andrew Gierth)
</P
></LI
><LI
><P
> Exempt tables that have per-table <TT
CLASS="VARNAME"
>cost_limit</TT
>
and/or <TT
CLASS="VARNAME"
>cost_delay</TT
> settings from autovacuum's global cost
balancing rules (Álvaro Herrera)
</P
><P
> The previous behavior resulted in basically ignoring these per-table
settings, which was unintended. Now, a table having such settings
will be vacuumed using those settings, independently of what is going
on in other autovacuum workers. This may result in heavier total I/O
load than before, so such settings should be re-examined for sanity.
</P
></LI
><LI
><P
> Avoid wholesale autovacuuming when autovacuum is nominally off
(Tom Lane)
</P
><P
> Even when autovacuum is nominally off, we will still launch autovacuum
worker processes to vacuum tables that are at risk of XID wraparound.
However, such a worker process then proceeded to vacuum all tables in
the target database, if they met the usual thresholds for
autovacuuming. This is at best pretty unexpected; at worst it delays
response to the wraparound threat. Fix it so that if autovacuum is
turned off, workers <SPAN
CLASS="emphasis"
><I
CLASS="EMPHASIS"
>only</I
></SPAN
> do anti-wraparound vacuums and
not any other work.
</P
></LI
><LI
><P
> During crash recovery, ensure that unlogged relations are rewritten as
empty and are synced to disk before recovery is considered complete
(Abhijit Menon-Sen, Andres Freund)
</P
><P
> This prevents scenarios in which unlogged relations might contain
garbage data following database crash recovery.
</P
></LI
><LI
><P
> Fix race condition between hot standby queries and replaying a
full-page image (Heikki Linnakangas)
</P
><P
> This mistake could result in transient errors in queries being
executed in hot standby.
</P
></LI
><LI
><P
> Fix several cases where recovery logic improperly ignored WAL records
for <TT
CLASS="LITERAL"
>COMMIT/ABORT PREPARED</TT
> (Heikki Linnakangas)
</P
><P
> The most notable oversight was
that <TT
CLASS="VARNAME"
>recovery_target_xid</TT
> could not be used to stop at
a two-phase commit.
</P
></LI
><LI
><P
> Prevent latest WAL file from being archived a second time at completion
of crash recovery (Fujii Masao)
</P
></LI
><LI
><P
> Avoid creating unnecessary <TT
CLASS="FILENAME"
>.ready</TT
> marker files for
timeline history files (Fujii Masao)
</P
></LI
><LI
><P
> Fix possible null pointer dereference when an empty prepared statement
is used and the <TT
CLASS="VARNAME"
>log_statement</TT
> setting is <TT
CLASS="LITERAL"
>mod</TT
>
or <TT
CLASS="LITERAL"
>ddl</TT
> (Fujii Masao)
</P
></LI
><LI
><P
> Change <SPAN
CLASS="QUOTE"
>"pgstat wait timeout"</SPAN
> warning message to be LOG level,
and rephrase it to be more understandable (Tom Lane)
</P
><P
> This message was originally thought to be essentially a can't-happen
case, but it occurs often enough on our slower buildfarm members to be
a nuisance. Reduce it to LOG level, and expend a bit more effort on
the wording: it now reads <SPAN
CLASS="QUOTE"
>"using stale statistics instead of
current ones because stats collector is not responding"</SPAN
>.
</P
></LI
><LI
><P
> Fix SPARC spinlock implementation to ensure correctness if the CPU is
being run in a non-TSO coherency mode, as some non-Solaris kernels do
(Andres Freund)
</P
></LI
><LI
><P
> Warn if macOS's <CODE
CLASS="FUNCTION"
>setlocale()</CODE
> starts an unwanted extra
thread inside the postmaster (Noah Misch)
</P
></LI
><LI
><P
> Fix processing of repeated <TT
CLASS="LITERAL"
>dbname</TT
> parameters
in <CODE
CLASS="FUNCTION"
>PQconnectdbParams()</CODE
> (Alex Shulgin)
</P
><P
> Unexpected behavior ensued if the first occurrence
of <TT
CLASS="LITERAL"
>dbname</TT
> contained a connection string or URI to be
expanded.
</P
></LI
><LI
><P
> Ensure that <SPAN
CLASS="APPLICATION"
>libpq</SPAN
> reports a suitable error message on
unexpected socket EOF (Marko Tiikkaja, Tom Lane)
</P
><P
> Depending on kernel behavior, <SPAN
CLASS="APPLICATION"
>libpq</SPAN
> might return an
empty error string rather than something useful when the server
unexpectedly closed the socket.
</P
></LI
><LI
><P
> Clear any old error message during <CODE
CLASS="FUNCTION"
>PQreset()</CODE
>
(Heikki Linnakangas)
</P
><P
> If <CODE
CLASS="FUNCTION"
>PQreset()</CODE
> is called repeatedly, and the connection
cannot be re-established, error messages from the failed connection
attempts kept accumulating in the <TT
CLASS="STRUCTNAME"
>PGconn</TT
>'s error
string.
</P
></LI
><LI
><P
> Properly handle out-of-memory conditions while parsing connection
options in <SPAN
CLASS="APPLICATION"
>libpq</SPAN
> (Alex Shulgin, Heikki Linnakangas)
</P
></LI
><LI
><P
> Fix array overrun in <SPAN
CLASS="APPLICATION"
>ecpg</SPAN
>'s version
of <CODE
CLASS="FUNCTION"
>ParseDateTime()</CODE
> (Michael Paquier)
</P
></LI
><LI
><P
> In <SPAN
CLASS="APPLICATION"
>initdb</SPAN
>, give a clearer error message if a password
file is specified but is empty (Mats Erik Andersson)
</P
></LI
><LI
><P
> Fix <SPAN
CLASS="APPLICATION"
>psql</SPAN
>'s <TT
CLASS="COMMAND"
>\s</TT
> command to work nicely with
libedit, and add pager support (Stepan Rutz, Tom Lane)
</P
><P
> When using libedit rather than readline, <TT
CLASS="COMMAND"
>\s</TT
> printed the
command history in a fairly unreadable encoded format, and on recent
libedit versions might fail altogether. Fix that by printing the
history ourselves rather than having the library do it. A pleasant
side-effect is that the pager is used if appropriate.
</P
><P
> This patch also fixes a bug that caused newline encoding to be applied
inconsistently when saving the command history with libedit.
Multiline history entries written by older <SPAN
CLASS="APPLICATION"
>psql</SPAN
>
versions will be read cleanly with this patch, but perhaps not
vice versa, depending on the exact libedit versions involved.
</P
></LI
><LI
><P
> Improve consistency of parsing of <SPAN
CLASS="APPLICATION"
>psql</SPAN
>'s special
variables (Tom Lane)
</P
><P
> Allow variant spellings of <TT
CLASS="LITERAL"
>on</TT
> and <TT
CLASS="LITERAL"
>off</TT
> (such
as <TT
CLASS="LITERAL"
>1</TT
>/<TT
CLASS="LITERAL"
>0</TT
>) for <TT
CLASS="LITERAL"
>ECHO_HIDDEN</TT
>
and <TT
CLASS="LITERAL"
>ON_ERROR_ROLLBACK</TT
>. Report a warning for unrecognized
values for <TT
CLASS="LITERAL"
>COMP_KEYWORD_CASE</TT
>, <TT
CLASS="LITERAL"
>ECHO</TT
>,
<TT
CLASS="LITERAL"
>ECHO_HIDDEN</TT
>, <TT
CLASS="LITERAL"
>HISTCONTROL</TT
>,
<TT
CLASS="LITERAL"
>ON_ERROR_ROLLBACK</TT
>, and <TT
CLASS="LITERAL"
>VERBOSITY</TT
>. Recognize
all values for all these variables case-insensitively; previously
there was a mishmash of case-sensitive and case-insensitive behaviors.
</P
></LI
><LI
><P
> Fix <SPAN
CLASS="APPLICATION"
>psql</SPAN
>'s expanded-mode display to work
consistently when using <TT
CLASS="LITERAL"
>border</TT
> = 3
and <TT
CLASS="LITERAL"
>linestyle</TT
> = <TT
CLASS="LITERAL"
>ascii</TT
> or <TT
CLASS="LITERAL"
>unicode</TT
>
(Stephen Frost)
</P
></LI
><LI
><P
> Improve performance of <SPAN
CLASS="APPLICATION"
>pg_dump</SPAN
> when the database
contains many instances of multiple dependency paths between the same
two objects (Tom Lane)
</P
></LI
><LI
><P
> Fix <SPAN
CLASS="APPLICATION"
>pg_dumpall</SPAN
> to restore its ability to dump from
pre-8.1 servers (Gilles Darold)
</P
></LI
><LI
><P
> Fix possible deadlock during parallel restore of a schema-only dump
(Robert Haas, Tom Lane)
</P
></LI
><LI
><P
> Fix core dump in <TT
CLASS="LITERAL"
>pg_dump --binary-upgrade</TT
> on zero-column
composite type (Rushabh Lathia)
</P
></LI
><LI
><P
> Prevent WAL files created by <TT
CLASS="LITERAL"
>pg_basebackup -x/-X</TT
> from
being archived again when the standby is promoted (Andres Freund)
</P
></LI
><LI
><P
> Fix failure of <TT
CLASS="FILENAME"
>contrib/auto_explain</TT
> to print per-node
timing information when doing <TT
CLASS="COMMAND"
>EXPLAIN ANALYZE</TT
> (Tom Lane)
</P
></LI
><LI
><P
> Fix upgrade-from-unpackaged script for <TT
CLASS="FILENAME"
>contrib/citext</TT
>
(Tom Lane)
</P
></LI
><LI
><P
> Fix block number checking
in <TT
CLASS="FILENAME"
>contrib/pageinspect</TT
>'s <CODE
CLASS="FUNCTION"
>get_raw_page()</CODE
>
(Tom Lane)
</P
><P
> The incorrect checking logic could prevent access to some pages in
non-main relation forks.
</P
></LI
><LI
><P
> Fix <TT
CLASS="FILENAME"
>contrib/pgcrypto</TT
>'s <CODE
CLASS="FUNCTION"
>pgp_sym_decrypt()</CODE
>
to not fail on messages whose length is 6 less than a power of 2
(Marko Tiikkaja)
</P
></LI
><LI
><P
> Fix file descriptor leak in <TT
CLASS="FILENAME"
>contrib/pg_test_fsync</TT
>
(Jeff Janes)
</P
><P
> This could cause failure to remove temporary files on Windows.
</P
></LI
><LI
><P
> Handle unexpected query results, especially NULLs, safely in
<TT
CLASS="FILENAME"
>contrib/tablefunc</TT
>'s <CODE
CLASS="FUNCTION"
>connectby()</CODE
>
(Michael Paquier)
</P
><P
> <CODE
CLASS="FUNCTION"
>connectby()</CODE
> previously crashed if it encountered a NULL
key value. It now prints that row but doesn't recurse further.
</P
></LI
><LI
><P
> Avoid a possible crash in <TT
CLASS="FILENAME"
>contrib/xml2</TT
>'s
<CODE
CLASS="FUNCTION"
>xslt_process()</CODE
> (Mark Simonetti)
</P
><P
> <SPAN
CLASS="APPLICATION"
>libxslt</SPAN
> seems to have an undocumented dependency on
the order in which resources are freed; reorder our calls to avoid a
crash.
</P
></LI
><LI
><P
> Mark some <TT
CLASS="FILENAME"
>contrib</TT
> I/O functions with correct volatility
properties (Tom Lane)
</P
><P
> The previous over-conservative marking was immaterial in normal use,
but could cause optimization problems or rejection of valid index
expression definitions. Since the consequences are not large, we've
just adjusted the function definitions in the extension modules'
scripts, without changing version numbers.
</P
></LI
><LI
><P
> Numerous cleanups of warnings from Coverity static code analyzer
(Andres Freund, Tatsuo Ishii, Marko Kreen, Tom Lane, Michael Paquier)
</P
><P
> These changes are mostly cosmetic but in some cases fix corner-case
bugs, for example a crash rather than a proper error report after an
out-of-memory failure. None are believed to represent security
issues.
</P
></LI
><LI
><P
> Detect incompatible OpenLDAP versions during build (Noah Misch)
</P
><P
> With OpenLDAP versions 2.4.24 through 2.4.31,
inclusive, <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> backends can crash at exit.
Raise a warning during <SPAN
CLASS="APPLICATION"
>configure</SPAN
> based on the
compile-time OpenLDAP version number, and test the crashing scenario
in the <TT
CLASS="FILENAME"
>contrib/dblink</TT
> regression test.
</P
></LI
><LI
><P
> In non-MSVC Windows builds, ensure <TT
CLASS="FILENAME"
>libpq.dll</TT
> is installed
with execute permissions (Noah Misch)
</P
></LI
><LI
><P
> Make <SPAN
CLASS="APPLICATION"
>pg_regress</SPAN
> remove any temporary installation it
created upon successful exit (Tom Lane)
</P
><P
> This results in a very substantial reduction in disk space usage
during <TT
CLASS="LITERAL"
>make check-world</TT
>, since that sequence involves
creation of numerous temporary installations.
</P
></LI
><LI
><P
> Support time zone abbreviations that change UTC offset from time to
time (Tom Lane)
</P
><P
> Previously, <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> assumed that the UTC offset
associated with a time zone abbreviation (such as <TT
CLASS="LITERAL"
>EST</TT
>)
never changes in the usage of any particular locale. However this
assumption fails in the real world, so introduce the ability for a
zone abbreviation to represent a UTC offset that sometimes changes.
Update the zone abbreviation definition files to make use of this
feature in timezone locales that have changed the UTC offset of their
abbreviations since 1970 (according to the IANA timezone database).
In such timezones, <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> will now associate the
correct UTC offset with the abbreviation depending on the given date.
</P
></LI
><LI
><P
> Update time zone abbreviations lists (Tom Lane)
</P
><P
> Add CST (China Standard Time) to our lists.
Remove references to ADT as <SPAN
CLASS="QUOTE"
>"Arabia Daylight Time"</SPAN
>, an
abbreviation that's been out of use since 2007; therefore, claiming
there is a conflict with <SPAN
CLASS="QUOTE"
>"Atlantic Daylight Time"</SPAN
> doesn't seem
especially helpful.
Fix entirely incorrect GMT offsets for CKT (Cook Islands), FJT, and FJST
(Fiji); we didn't even have them on the proper side of the date line.
</P
></LI
><LI
><P
> Update time zone data files to <SPAN
CLASS="APPLICATION"
>tzdata</SPAN
> release 2015a.
</P
><P
> The IANA timezone database has adopted abbreviations of the form
<TT
CLASS="LITERAL"
>A<TT
CLASS="REPLACEABLE"
><I
>x</I
></TT
>ST</TT
>/<TT
CLASS="LITERAL"
>A<TT
CLASS="REPLACEABLE"
><I
>x</I
></TT
>DT</TT
>
for all Australian time zones, reflecting what they believe to be
current majority practice Down Under. These names do not conflict
with usage elsewhere (other than ACST for Acre Summer Time, which has
been in disuse since 1994). Accordingly, adopt these names into
our <SPAN
CLASS="QUOTE"
>"Default"</SPAN
> timezone abbreviation set.
The <SPAN
CLASS="QUOTE"
>"Australia"</SPAN
> abbreviation set now contains only CST, EAST,
EST, SAST, SAT, and WST, all of which are thought to be mostly
historical usage. Note that SAST has also been changed to be South
Africa Standard Time in the <SPAN
CLASS="QUOTE"
>"Default"</SPAN
> abbreviation set.
</P
><P
> Also, add zone abbreviations SRET (Asia/Srednekolymsk) and XJT
(Asia/Urumqi), and use WSST/WSDT for western Samoa. Also, there were
DST law changes in Chile, Mexico, the Turks & Caicos Islands
(America/Grand_Turk), and Fiji. There is a new zone
Pacific/Bougainville for portions of Papua New Guinea. Also, numerous
corrections for historical (pre-1970) time zone data.
</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-9-2-11.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-9-2-9.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Release 9.2.11</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 9.2.9</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>