Appendix E. Release Notes
Improve pg_dump’s handling of inherited table columns (Tom Lane)
pg_dump mishandled situations where a child column has a different default expression than its
parent column. If the default is textually identical to the parent’s default, but not actually the same
(for instance, because of schema search pathdifferences) itwouldnotbe recognized as different, so
thatafter dump and restorethechild would be allowedto inheritthe parent’s default. Childcolumns
where their parent is not could also be restored subtly incorrectly.
Fix pg_restore’s direct-to-database mode for INSERT-style table data (Tom Lane)
Direct-to-database restores from archive ﬁles made with
tions fail when using pg_restore from a release dated September or December 2011, as a result of
anoversightin a ﬁx for another problem. The archive ﬁle itself is not at fault, andtext-mode output
Allow pg_upgrade to process tables containing
columns (Bruce Momjian)
Since pg_upgrade now takes care to preserve
OIDs, there was no longer any reason for
errors when looking for an SSL client certiﬁcate ﬁle (Magnus Hagan-
This allows SSL connections to be established, though without a certiﬁcate, even when the user’s
home directory is set to something like
Fix some more ﬁeld alignment issues in ecpg’s SQLDA area (Zoltan Boszormenyi)
statements (Michael Meskes)
The infrastructure to support this has been there for awhile, but through an oversight there was still
an error check rejecting the case.
Do not use the variable name when deﬁning a varchar structure in ecpg (Michael Meskes)
’s JSONoutput mode to produce valid JSON (Andrew Dunstan)
The output used brackets at the top level, when it should have used braces.
Fix error in
int & int
operator (Guillaume Lelarge)
If the smallest integer the two input arrays have in common is 1, and there are smaller values in
either array, then 1would be incorrectly omitted from the result.
Fix error detectionin
These functions failed to report certain types of invalid-input errors, and would instead return ran-
dom garbage values for incorrect input.
Fix one-byte buffer overrun in
The code would try to read one more byte than it should, which would crash in corner cases. Since
is onlyexample code, this isnota securityissue in itself, butbadexample
code is still bad.
for spinlocks on ARM, if available (Martin Pitt)
This function replaces our previous use of the
instruction, which is deprecated and not avail-
able on ARMv6 and later. Reports suggest that the old code doesn’t fail in an obvious way on
recent ARM boards, butsimply doesn’t interlock concurrent accesses, leadingto bizarre failures in
This prevents assorted scenarios wherein recent versions of gcc will produce creative results.