Appendix E. Release Notes
variables work as expected in sort routines, and that function compilation is signiﬁcantly faster.
Prevent PL/Tcl from executing untrustworthy code from
PL/Tcl’s feature for autoloading Tcl code from a database table could be exploited for trojan-horse
attacks, because there was no restriction on who could create or insert into that table. This change
disables the feature unless
is owned by a superuser. (However, the permissions
on the table are not checked, so installations that really need a less-than-secure modules table
can still grant suitable privileges to trusted non-superusers.) Also, prevent loading code into the
unrestricted “normal” Tcl interpreter unless we are really going to execute a
Fix possible crash if a cache reset message is received during rebuild of a relcache entry (Heikki)
This error was introduced in 8.2.16 while ﬁxing a related failure.
Do not allow an unprivileged user to reset superuser-only parameter settings (Alvaro)
Previously, if an unprivileged user ran
ALTER USER ... RESET ALL
for himself, or
DATABASE ... RESET ALL
for a database he owns, this would remove all special parameter
settings for the user or database, even ones that are only supposed to be changeable by a superuser.
will only remove the parameters that the user has permission to change.
Avoidpossiblecrashduringbackendshutdown if shutdownoccurswhena
be made to log entries (Tom)
In some cases the context-printing function would fail because the current transaction had already
been rolled back when it came time to print a logmessage.
for modern Perl versions (Andrew)
Fix assorted memory leaks in pl/python (Andreas Freund, Tom)
Prevent inﬁnite recursion in psql when expanding a variable that refers to itself (Tom)
to not add spaces around a dot within
\copy (select ...)
Addition of spaces around the decimal point in a numeric literal would result in a syntax error.
functions respond to cancel interrupts promptly (Tatsuhito
Make server startup deal properly with the case that
for an existing
shared memory segment (Tom)
This behavior has been observedonBSD-derived kernels includingOS X. It resulted in anentirely-
misleading startup failure complaining that the shared memory request size was too large.
Avoid possible crashes in syslogger process on Windows (Heikki)
Deal more robustly with incomplete time zone information in the Windows registry (Magnus)
Update the set of known Windows time zone names (Magnus)
Update time zone data ﬁles to tzdata release 2010j for DST law changes in Argentina, Australian
Antarctic, Bangladesh, Mexico, Morocco, Pakistan, Palestine, Russia, Syria, Tunisia; also historical
corrections for Taiwan.
(PakistanSummer Time) to the default set of timezone abbreviations.