Stamp 9.4.10.
commit : c7681b2b9a115eb05048a485480826bc0efa6d3b
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 24 Oct 2016 16:12:53 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 24 Oct 2016 16:12:53 -0400
M configure
M configure.in
M doc/bug.template
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc
Translation updates
commit : 117add5fd848df3def3196bfb76455555382cd51
author : Peter Eisentraut <peter_e@gmx.net>
date : Mon, 24 Oct 2016 12:00:00 -0400
committer: Peter Eisentraut <peter_e@gmx.net>
date : Mon, 24 Oct 2016 12:00:00 -0400
Source-Git-URL: git://git.postgresql.org/git/pgtranslation/messages.git
Source-Git-Hash: 475f2bcc7c56f293db4e62d31f85b3bfc0f9f279
M src/backend/po/de.po
M src/backend/po/pl.po
M src/backend/po/ru.po
M src/bin/initdb/po/ru.po
M src/bin/pg_basebackup/po/ru.po
M src/bin/pg_config/po/ru.po
M src/bin/pg_controldata/po/ru.po
M src/bin/pg_ctl/po/ru.po
M src/bin/pg_dump/po/de.po
M src/bin/pg_dump/po/pl.po
M src/bin/pg_dump/po/pt_BR.po
M src/bin/pg_dump/po/ru.po
M src/bin/pg_resetxlog/po/pl.po
M src/bin/pg_resetxlog/po/ru.po
M src/bin/psql/po/de.po
M src/bin/psql/po/pt_BR.po
M src/bin/psql/po/ru.po
M src/bin/scripts/po/ru.po
M src/interfaces/ecpg/ecpglib/po/ru.po
M src/interfaces/ecpg/preproc/po/de.po
M src/interfaces/ecpg/preproc/po/es.po
M src/interfaces/ecpg/preproc/po/fr.po
M src/interfaces/ecpg/preproc/po/it.po
M src/interfaces/ecpg/preproc/po/pl.po
M src/interfaces/ecpg/preproc/po/pt_BR.po
M src/interfaces/ecpg/preproc/po/ru.po
M src/interfaces/ecpg/preproc/po/zh_CN.po
M src/interfaces/libpq/po/ru.po
M src/interfaces/libpq/po/zh_CN.po
M src/interfaces/libpq/po/zh_TW.po
M src/pl/plperl/po/ru.po
M src/pl/plpgsql/src/po/ru.po
M src/pl/plpython/po/ru.po
M src/pl/tcl/po/ru.po
Release notes for 9.6.1, 9.5.5, 9.4.10, 9.3.15, 9.2.19, 9.1.24.
commit : 41d14fccd285e7a79b053808934b37714cdb3fe1
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Sun, 23 Oct 2016 22:13:28 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Sun, 23 Oct 2016 22:13:28 -0400
M doc/src/sgml/release-9.1.sgml
M doc/src/sgml/release-9.2.sgml
M doc/src/sgml/release-9.3.sgml
M doc/src/sgml/release-9.4.sgml
Avoid testing tuple visibility without buffer lock in RI_FKey_check().
commit : 9ec21591ff11b60e44bfa44fd596ab52022741b3
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Sun, 23 Oct 2016 15:01:24 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Sun, 23 Oct 2016 15:01:24 -0400
Despite the argumentation I wrote in commit 7a2fe85b0, it's unsafe to do
this, because in corner cases it's possible for HeapTupleSatisfiesSelf
to try to set hint bits on the target tuple; and at least since 8.2 we
have required the buffer content lock to be held while setting hint bits.
The added regression test exercises one such corner case. Unpatched, it
causes an assertion failure in assert-enabled builds, or otherwise would
cause a hint bit change in a buffer we don't hold lock on, which given
the right race condition could result in checksum failures or other data
consistency problems. The odds of a problem in the field are probably
pretty small, but nonetheless back-patch to all supported branches.
Report: <19391.1477244876@sss.pgh.pa.us>
M src/backend/utils/adt/ri_triggers.c
M src/test/regress/expected/foreign_key.out
M src/test/regress/sql/foreign_key.sql
Improve documentation about use of Linux huge pages.
commit : b0051f1d4c9f6db51b4a8b7ba8978548cfbc0918
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 22 Oct 2016 14:04:51 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 22 Oct 2016 14:04:51 -0400
Show how to get the system's huge page size, rather than misleadingly
referring to PAGE_SIZE (which is usually understood to be the regular
page size). Show how to confirm whether huge pages have been allocated.
Minor wordsmithing. Back-patch to 9.4 where this section appeared.
M doc/src/sgml/runtime.sgml
Doc: wording tweak for PERL, PYTHON, TCLSH configuration variables.
commit : 63d8de2c9e8588f458b568d3b08a4d3fa109e0fb
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 21 Oct 2016 11:01:35 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 21 Oct 2016 11:01:35 -0400
Replace "Full path to ..." with "Full path name of ...". At least one
user has misinterpreted the existing wording as meaning "Directory
containing ...".
M doc/src/sgml/installation.sgml
Fix EXPLAIN so that it doesn't emit invalid XML in corner cases.
commit : adb199711a8cc5f1f283b2bc7e4f76ed4b6def72
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 20 Oct 2016 17:17:50 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 20 Oct 2016 17:17:50 -0400
With track_io_timing = on, EXPLAIN (ANALYZE, BUFFERS) will emit fields
named like "I/O Read Time". The slash makes that invalid as an XML
element name, so that adding FORMAT XML would produce invalid XML.
We already have code in there to translate spaces to dashes, so let's
generalize that to convert anything that isn't a valid XML name character,
viz letters, digits, hyphens, underscores, and periods. We could just
reject slashes, which would run a bit faster. But the fact that this went
unnoticed for so long doesn't give me a warm feeling that we'd notice the
next creative violation, so let's make it a permanent fix.
Reported by Markus Winand, though this isn't his initial patch proposal.
Back-patch to 9.2 where track_io_timing was added. The problem is only
latent in 9.1, so I don't feel a need to fix it there.
Discussion: <E0BF6A45-68E8-45E6-918F-741FB332C6BB@winand.at>
M src/backend/commands/explain.c
Sync our copy of the timezone library with IANA release tzcode2016h.
commit : a8518738ae8c92813da13a13a2c79ab13c79263f
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 20 Oct 2016 15:40:07 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 20 Oct 2016 15:40:07 -0400
This absorbs a fix for a symlink-manipulation bug in zic that was
introduced in 2016g. It probably isn't interesting for our use-case,
but I'm not quite sure, so let's update while we're at it.
M src/timezone/zic.c
Update time zone data files to tzdata release 2016h.
commit : 1d388ba2ccde16fe58aab0fd187493acce3cecb6
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 20 Oct 2016 15:20:11 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 20 Oct 2016 15:20:11 -0400
(Didn't I just do this? Oh well.)
DST law changes in Palestine. Historical corrections for Turkey.
Switch to numeric abbreviations for Asia/Colombo.
M src/timezone/data/asia
M src/timezone/data/australasia
M src/timezone/data/europe
M src/timezone/data/northamerica
M src/timezone/known_abbrevs.txt
Another portability fix for tzcode2016g update.
commit : 65935033d64cb5ad51f7e5967860d545400beccd
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 19 Oct 2016 23:32:08 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 19 Oct 2016 23:32:08 -0400
clang points out that SIZE_MAX wouldn't fit into an int, which means
this comparison is pretty useless. Per report from Thomas Munro.
M src/timezone/zic.c
Windows portability fix.
commit : fba888a8779e16ae25c1443e3a7fdea44817c87c
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 19 Oct 2016 19:28:11 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 19 Oct 2016 19:28:11 -0400
Per buildfarm.
M src/timezone/zic.c
Sync our copy of the timezone library with IANA release tzcode2016g.
commit : 381c4b03b3956f0a9e2eb9a83e4b3038e959adde
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 19 Oct 2016 18:55:52 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 19 Oct 2016 18:55:52 -0400
This is mostly to absorb some corner-case fixes in zic for year-2037
timestamps. The other changes that have been made are unlikely to affect
our usage, but nonetheless we may as well take 'em.
M src/timezone/localtime.c
M src/timezone/private.h
M src/timezone/strftime.c
M src/timezone/zic.c
Suppress "Factory" zone in pg_timezone_names view for tzdata >= 2016g.
commit : 63a4bc45ea515346a3b4e68b86e7eabf8c638cfe
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 19 Oct 2016 18:11:49 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 19 Oct 2016 18:11:49 -0400
IANA got rid of the really silly "abbreviation" and replaced it with one
that's only moderately silly. But it's still pointless, so keep on not
showing it.
M src/backend/utils/adt/datetime.c
Update time zone data files to tzdata release 2016g.
commit : 9727dac58e81d198ec115af594735f1f01c55f00
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 19 Oct 2016 17:56:38 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 19 Oct 2016 17:56:38 -0400
DST law changes in Turkey. Historical corrections for America/Los_Angeles,
Europe/Kirov, Europe/Moscow, Europe/Samara, and Europe/Ulyanovsk.
Rename Asia/Rangoon to Asia/Yangon, with a backward compatibility link.
The IANA crew continue their campaign to replace invented time zone
abbrevations with numeric GMT offsets. This update changes numerous zones
in Antarctica and the former Soviet Union, for instance Antarctica/Casey
now reports "+08" not "AWST" in the pg_timezone_names view. I kept these
abbreviations in the tznames/ data files, however, so that we will still
accept them for input. (We may want to start trimming those files someday,
but today is not that day.)
An exception is that since IANA no longer claims that "AMT" is in use
in Armenia for GMT+4, I replaced it in the Default file with GMT-4,
corresponding to Amazon Time which is in use in South America. It may be
that that meaning is also invented and IANA will drop it in a future
update; but for now, it seems silly to give pride of place to a meaning
not traceable to IANA over one that is.
M src/timezone/data/africa
M src/timezone/data/antarctica
M src/timezone/data/asia
M src/timezone/data/australasia
M src/timezone/data/backward
M src/timezone/data/backzone
M src/timezone/data/etcetera
M src/timezone/data/europe
M src/timezone/data/factory
M src/timezone/data/northamerica
M src/timezone/data/southamerica
M src/timezone/known_abbrevs.txt
M src/timezone/tznames/Antarctica.txt
M src/timezone/tznames/Asia.txt
M src/timezone/tznames/Default
M src/timezone/tznames/Europe.txt
M src/timezone/tznames/Indian.txt
Fix WAL-logging of FSM and VM truncation.
commit : 2523bef15e446d25d16b206bac3b6ef6ad6a8a7d
author : Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Wed, 19 Oct 2016 14:43:34 +0300
committer: Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Wed, 19 Oct 2016 14:43:34 +0300
When a relation is truncated, it is important that the FSM is truncated as
well. Otherwise, after recovery, the FSM can return a page that has been
truncated away, leading to errors like:
ERROR: could not read block 28991 in file "base/16390/572026": read only 0
of 8192 bytes
We were using MarkBufferDirtyHint() to dirty the buffer holding the last
remaining page of the FSM, but during recovery, that might in fact not
dirty the page, and the FSM update might be lost.
To fix, use the stronger MarkBufferDirty() function. MarkBufferDirty()
requires us to do WAL-logging ourselves, to protect from a torn page, if
checksumming is enabled.
Also fix an oversight in visibilitymap_truncate: it also needs to WAL-log
when checksumming is enabled.
Analysis by Pavan Deolasee.
Discussion: <CABOikdNr5vKucqyZH9s1Mh0XebLs_jRhKv6eJfNnD2wxTn=_9A@mail.gmail.com>
Backpatch to 9.3, where we got data checksums.
M src/backend/access/heap/visibilitymap.c
M src/backend/storage/freespace/freespace.c
Fix cidin() to handle values above 2^31 platform-independently.
commit : ad8cd4baa3a451887b22b104b2dc2f53133537d4
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Tue, 18 Oct 2016 12:24:46 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Tue, 18 Oct 2016 12:24:46 -0400
CommandId is declared as uint32, and values up to 4G are indeed legal.
cidout() handles them properly by treating the value as unsigned int.
But cidin() was just using atoi(), which has platform-dependent behavior
for values outside the range of signed int, as reported by Bart Lengkeek
in bug #14379. Use strtoul() instead, as xidin() does.
In passing, make some purely cosmetic changes to make xidin/xidout
look more like cidin/cidout; the former didn't have a monopoly on
best practice IMO.
Neither xidin nor cidin make any attempt to throw error for invalid input.
I didn't change that here, and am not sure it's worth worrying about
since neither is really a user-facing type. The point is just to ensure
that indubitably-valid inputs work as expected.
It's been like this for a long time, so back-patch to all supported
branches.
Report: <20161018152550.1413.6439@wrigleys.postgresql.org>
M src/backend/utils/adt/xid.c
Fix assorted integer-overflow hazards in varbit.c.
commit : b4f486b267913bb8f10cbf9d5ec6ff071e38e297
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 14 Oct 2016 16:28:34 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 14 Oct 2016 16:28:34 -0400
bitshiftright() and bitshiftleft() would recursively call each other
infinitely if the user passed INT_MIN for the shift amount, due to integer
overflow in negating the shift amount. To fix, clamp to -VARBITMAXLEN.
That doesn't change the results since any shift distance larger than the
input bit string's length produces an all-zeroes result.
Also fix some places that seemed inadequately paranoid about input typmods
exceeding VARBITMAXLEN. While a typmod accepted by anybit_typmodin() will
certainly be much less than that, at least some of these spots are
reachable with user-chosen integer values.
Andreas Seltenreich and Tom Lane
Discussion: <87d1j2zqtz.fsf@credativ.de>
M src/backend/utils/adt/varbit.c
Fix another bug in merging of inherited CHECK constraints.
commit : f2024d59ae7f20b8d51eaf29e543c50ec88488f0
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 13 Oct 2016 17:05:15 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 13 Oct 2016 17:05:15 -0400
It's not good for an inherited child constraint to be marked connoinherit;
that would result in the constraint not propagating to grandchild tables,
if any are created later. The code mostly prevented this from happening
but there was one case that was missed.
This is somewhat related to commit e55a946a8, which also tightened checks
on constraint merging. Hence, back-patch to 9.2 like that one. This isn't
so much because there's a concrete feature-related reason to stop there,
as to avoid having more distinct behaviors than we have to in this area.
Amit Langote
Discussion: <b28ee774-7009-313d-dd55-5bdd81242c41@lab.ntt.co.jp>
M src/backend/catalog/heap.c
M src/test/regress/expected/inherit.out
M src/test/regress/sql/inherit.sql
Try to find out the actual hugepage size when making a MAP_HUGETLB request.
commit : 6d3cbbf5954250638ea5837bf514a6d392f2329e
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 13 Oct 2016 15:06:46 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 13 Oct 2016 15:06:46 -0400
Even if Linux's mmap() is okay with a partial-hugepage request, munmap()
is not, as reported by Chris Richards. Therefore it behooves us to try
a bit harder to find out the actual hugepage size, instead of assuming
that we can skate by with a guess.
For the moment, just look into /proc/meminfo to find out the default
hugepage size, and use that. Later, on kernels that support requests
for nondefault sizes, we might try to consider other alternatives.
But that smells more like a new feature than a bug fix, especially if
we want to provide any way for the DBA to control it, so leave it for
another day.
I set this up to allow easy addition of platform-specific code for
non-Linux platforms, if needed; but right now there are no reports
suggesting that we need to work harder on other platforms.
Back-patch to 9.4 where hugepage support was introduced.
Discussion: <31056.1476303954@sss.pgh.pa.us>
M src/backend/port/sysv_shmem.c
Clean up handling of anonymous mmap'd shared-memory segment.
commit : 573d2ed0e48fc59e8186a616ce8ba30960a9cec0
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 13 Oct 2016 13:59:56 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 13 Oct 2016 13:59:56 -0400
Fix detaching of the mmap'd segment to have its own on_shmem_exit callback,
rather than piggybacking on the one for detaching from the SysV segment.
That was confusing, and given the distance between the two attach calls,
it was trouble waiting to happen.
Make the detaching calls idempotent by clearing AnonymousShmem to show
we've already unmapped. I spent quite a bit of time yesterday trying
to find a path that would allow the munmap()'s to be done twice, and
while I did not succeed, it seems silly that there's even a question.
Make the #ifdef logic less confusing by separating "do we want to use
anonymous shmem" from EXEC_BACKEND. Even though there's no current
scenario where those conditions are different, it is not helpful for
different places in the same file to be testing EXEC_BACKEND for what
are fundamentally different reasons.
Don't do on_exit_reset() in StartBackgroundWorker(). At best that's
useless (InitPostmasterChild would have done it already) and at worst
it could zap some callback that's unrelated to shared memory.
Improve comments, and simplify the huge_pages enablement logic slightly.
Back-patch to 9.4 where hugepage support was introduced.
Arguably this should go into 9.3 as well, but the code looks
significantly different there, and I doubt it's worth the
trouble of adapting the patch given I can't show a live bug.
M src/backend/port/sysv_shmem.c
M src/backend/postmaster/bgworker.c
Revert addition of PGDLLEXPORT in PG_FUNCTION_INFO_V1 macro.
commit : 80296813cc3df61b7ab5aca69108680600a57f79
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 12 Oct 2016 18:01:43 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 12 Oct 2016 18:01:43 -0400
This turns out not to be as harmless as I thought: MSVC will complain
if it sees an "extern" declaration without PGDLLEXPORT and then one with.
(Seems fairly silly, given that this can be changed after the fact by the
linker, but there you have it.) Therefore, contrib modules that have
extern's for V1 functions in header files are falling over in the
buildfarm, since none of those externs are marked PGDLLEXPORT.
We might or might not conclude that we're willing to plaster those
declarations with PGDLLEXPORT in HEAD, but in any case there's no way we're
going to ship this change in the back branches. Third-party authors would
not thank us for breaking their code in a minor release. Hence, revert
the addition of PGDLLEXPORT (but let's keep the extra info in the comment).
If we do the other changes we can revert this commit in HEAD.
Per buildfarm.
M src/include/fmgr.h
Provide DLLEXPORT markers for C functions via PG_FUNCTION_INFO_V1 macro.
commit : ee6810fb4639cbf4da40eb647ae91ed59dd0deaf
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 12 Oct 2016 12:45:50 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 12 Oct 2016 12:45:50 -0400
This isn't really necessary for our own code, because we use a .DEF file
in MSVC builds (see gendef.pl), or --export-all-symbols in MinGW and
Cygwin builds, to ensure that all global symbols in loadable modules
will be exported on Windows. However, third-party authors might use
different build processes that need this marker, and it's harmless
enough for our own builds.
To some extent, this is an oversight in commit e7128e8db, so back-patch
to 9.4 where that was added.
Laurenz Albe
Discussion: <A737B7A37273E048B164557ADEF4A58B539300BD@ntex2010a.host.magwien.gv.at>
M src/include/fmgr.h
Fix copy-pasto in comment.
commit : 69ade952e9c444e64c96465157b0e6b7456143db
author : Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Wed, 12 Oct 2016 12:07:54 +0300
committer: Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Wed, 12 Oct 2016 12:07:54 +0300
Amit Langote
M src/include/catalog/pg_cast.h
Improve documentation for CREATE RECURSIVE VIEW.
commit : 33473208b8990e66e94b24cfe0cfc944b8748bdb
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Tue, 11 Oct 2016 10:08:45 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Tue, 11 Oct 2016 10:08:45 -0400
It was perhaps not entirely clear that internal self-references shouldn't
be schema-qualified even if the view name is written with a schema.
Spell it out.
Discussion: <871sznz69m.fsf@metapensiero.it>
M doc/src/sgml/ref/create_view.sgml
In PQsendQueryStart(), avoid leaking any left-over async result.
commit : eb6bc03bfb43a11e15c2e24d9f6069add284f930
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Oct 2016 10:35:58 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 10 Oct 2016 10:35:58 -0400
Ordinarily there would not be an async result sitting around at this
point, but it appears that in corner cases there can be. Considering
all the work we're about to launch, it's hardly going to cost anything
noticeable to check.
It's been like this forever, so back-patch to all supported branches.
Report: <CAD-Qf1eLUtBOTPXyFQGW-4eEsop31tVVdZPu4kL9pbQ6tJPO8g@mail.gmail.com>
M src/interfaces/libpq/fe-exec.c
Fix two bugs in merging of inherited CHECK constraints.
commit : 12230c47855f67d1288c058d8d0a5f8e1febe366
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 8 Oct 2016 19:29:27 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 8 Oct 2016 19:29:27 -0400
Historically, we've allowed users to add a CHECK constraint to a child
table and then add an identical CHECK constraint to the parent. This
results in "merging" the two constraints so that the pre-existing
child constraint ends up with both conislocal = true and coninhcount > 0.
However, if you tried to do it in the other order, you got a duplicate
constraint error. This is problematic for pg_dump, which needs to issue
separated ADD CONSTRAINT commands in some cases, but has no good way to
ensure that the constraints will be added in the required order.
And it's more than a bit arbitrary, too. The goal of complaining about
duplicated ADD CONSTRAINT commands can be served if we reject the case of
adding a constraint when the existing one already has conislocal = true;
but if it has conislocal = false, let's just make the ADD CONSTRAINT set
conislocal = true. In this way, either order of adding the constraints
has the same end result.
Another problem was that the code allowed creation of a parent constraint
marked convalidated that is merged with a child constraint that is
!convalidated. In this case, an inheritance scan of the parent table could
emit some rows violating the constraint condition, which would be an
unexpected result given the marking of the parent constraint as validated.
Hence, forbid merging of constraints in this case. (Note: valid child and
not-valid parent seems fine, so continue to allow that.)
Per report from Benedikt Grundmann. Back-patch to 9.2 where we introduced
possibly-not-valid check constraints. The second bug obviously doesn't
apply before that, and I think the first doesn't either, because pg_dump
only gets into this situation when dealing with not-valid constraints.
Report: <CADbMkNPT-Jz5PRSQ4RbUASYAjocV_KHUWapR%2Bg8fNvhUAyRpxA%40mail.gmail.com>
Discussion: <22108.1475874586@sss.pgh.pa.us>
M src/backend/catalog/heap.c
M src/backend/commands/tablecmds.c
M src/test/regress/expected/inherit.out
M src/test/regress/expected/sanity_check.out
M src/test/regress/sql/inherit.sql
Remove user_relns() SRF from regression tests.
commit : 48c473f6978273bab47d196df4c0e0e6f9cc0d91
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 8 Oct 2016 18:43:01 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 8 Oct 2016 18:43:01 -0400
Back-patch commit 0dba54f1666ead71c54ce100b39efda67596d297 into the older
branches. This test is almost as much of a patching hazard there as it is
in HEAD, and it has no more reason to be needed than it does in HEAD.
I went back as far as 9.2; I judged 9.1 not worth the trouble since
it's on the verge of being EOL'd.
M src/test/regress/input/create_function_2.source
M src/test/regress/input/misc.source
M src/test/regress/output/create_function_2.source
M src/test/regress/output/misc.source
Make TAP test suites to work, when @INC does not contain current dir.
commit : b803b8823517c277bbe4bf0d1b7ea4a39b446a8b
author : Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Fri, 7 Oct 2016 21:48:21 +0300
committer: Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Fri, 7 Oct 2016 21:48:21 +0300
Recent Perl and/or new Linux distributions are starting to remove "." from
the @INC list by default. That breaks pg_rewind and ssl test suites, which
use helper perl modules that reside in the same directory. To fix, add the
current source directory explicitly to prove's include dir.
The vcregress.pl script probably also needs something like this, but I
wasn't able to remove '.' from @INC on Windows to test this, and don't want
to try doing that blindly.
Discussion: <20160908204529.flg6nivjuwp5vaoy@alap3.anarazel.de>
M src/Makefile.global.in
Clear OpenSSL error queue after failed X509_STORE_load_locations() call.
commit : 418cd758abeb5bb7d359788a0599daa6de016b00
author : Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Fri, 7 Oct 2016 12:53:45 +0300
committer: Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Fri, 7 Oct 2016 12:53:45 +0300
Leaving the error in the error queue used to be harmless, because the
X509_STORE_load_locations() call used to be the last step in
initialize_SSL(), and we would clear the queue before the next
SSL_connect() call. But previous commit moved things around. The symptom
was that if a CRL file was not found, and one of the subsequent
initialization steps, like loading the client certificate or private key,
failed, we would incorrectly print the "no such file" error message from
the earlier X509_STORE_load_locations() call as the reason.
Backpatch to all supported versions, like the previous patch.
M src/interfaces/libpq/fe-secure.c
Don't share SSL_CTX between libpq connections.
commit : 31895abd8bf1bf1841b47116874bcb447b9d33b0
author : Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Fri, 7 Oct 2016 12:20:39 +0300
committer: Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Fri, 7 Oct 2016 12:20:39 +0300
There were several issues with the old coding:
1. There was a race condition, if two threads opened a connection at the
same time. We used a mutex around SSL_CTX_* calls, but that was not
enough, e.g. if one thread SSL_CTX_load_verify_locations() with one
path, and another thread set it with a different path, before the first
thread got to establish the connection.
2. Opening two different connections, with different sslrootcert settings,
seemed to fail outright with "SSL error: block type is not 01". Not sure
why.
3. We created the SSL object, before calling SSL_CTX_load_verify_locations
and SSL_CTX_use_certificate_chain_file on the SSL context. That was
wrong, because the options set on the SSL context are propagated to the
SSL object, when the SSL object is created. If they are set after the
SSL object has already been created, they won't take effect until the
next connection. (This is bug #14329)
At least some of these could've been fixed while still using a shared
context, but it would've been more complicated and error-prone. To keep
things simple, let's just use a separate SSL context for each connection,
and accept the overhead.
Backpatch to all supported versions.
Report, analysis and test case by Kacper Zuk.
Discussion: <20160920101051.1355.79453@wrigleys.postgresql.org>
M src/interfaces/libpq/fe-secure.c
Correct logical decoding restore behaviour for subtransactions.
commit : 07172b20f1a0c4e3a24b0b8f6781de4d2c4866cb
author : Andres Freund <andres@anarazel.de>
date : Mon, 3 Oct 2016 22:11:36 -0700
committer: Andres Freund <andres@anarazel.de>
date : Mon, 3 Oct 2016 22:11:36 -0700
Before initializing iteration over a subtransaction's changes, the last
few changes were not spilled to disk. That's correct if the transaction
didn't spill to disk, but otherwise... This bug can lead to missed or
misorderd subtransaction contents when they were spilled to disk.
Move spilling of the remaining in-memory changes to
ReorderBufferIterTXNInit(), where it can easily be applied to the top
transaction and, if present, subtransactions.
Since this code had too many bugs already, noticeably increase test
coverage.
Fixes: #14319
Reported-By: Huan Ruan
Discussion: <20160909012610.20024.58169@wrigleys.postgresql.org>
Backport: 9,4-, where logical decoding was added
M contrib/test_decoding/Makefile
A contrib/test_decoding/expected/spill.out
A contrib/test_decoding/sql/spill.sql
M src/backend/replication/logical/reorderbuffer.c
Do ClosePostmasterPorts() earlier in SubPostmasterMain().
commit : 475866f08725a01aac91417fc67b725b2511f435
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 1 Oct 2016 17:15:10 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 1 Oct 2016 17:15:10 -0400
In standard Unix builds, postmaster child processes do ClosePostmasterPorts
immediately after InitPostmasterChild, that is almost immediately after
being spawned. This is important because we don't want children holding
open the postmaster's end of the postmaster death watch pipe.
However, in EXEC_BACKEND builds, SubPostmasterMain was postponing this
responsibility significantly, in order to make it slightly more convenient
to pass the right flag value to ClosePostmasterPorts. This is bad,
particularly seeing that process_shared_preload_libraries() might invoke
nearly-arbitrary code. Rearrange so that we do it as soon as we've
fetched the socket FDs via read_backend_variables().
Also move the comment explaining about randomize_va_space to before the
call of PGSharedMemoryReAttach, which is where it's relevant. The old
placement was appropriate when the reattach happened inside
CreateSharedMemoryAndSemaphores, but that was a long time ago.
Back-patch to 9.3; the patch doesn't apply cleanly before that, and
it doesn't seem worth a lot of effort given that we've had no actual
field complaints traceable to this.
Discussion: <4157.1475178360@sss.pgh.pa.us>
M src/backend/postmaster/postmaster.c
Retry opening new segments in pg_xlogdump --folllow
commit : da3f71a080fb7a615f5074eee44e524b045740f3
author : Magnus Hagander <magnus@hagander.net>
date : Fri, 30 Sep 2016 11:19:30 +0200
committer: Magnus Hagander <magnus@hagander.net>
date : Fri, 30 Sep 2016 11:19:30 +0200
There is a small window between when the server closes out the existing
segment and the new one is created. Put a loop around the open call in
this case to make sure we wait for the new file to actually appear.
M contrib/pg_xlogdump/pg_xlogdump.c
worker_spi: Call pgstat_report_stat.
commit : a4daf8319923505b60c02b23bf3cfd1bd0b89d40
author : Robert Haas <rhaas@postgresql.org>
date : Wed, 28 Sep 2016 12:38:33 -0400
committer: Robert Haas <rhaas@postgresql.org>
date : Wed, 28 Sep 2016 12:38:33 -0400
Without this, statistics changes accumulated by the worker never get
reported to the stats collector, which is bad.
Julien Rouhaud
M contrib/worker_spi/worker_spi.c
Include <sys/select.h> where needed
commit : ce7b35e7e828b1f7d0e3835f84e81f3b8646f17c
author : Alvaro Herrera <alvherre@alvh.no-ip.org>
date : Tue, 27 Sep 2016 01:05:21 -0300
committer: Alvaro Herrera <alvherre@alvh.no-ip.org>
date : Tue, 27 Sep 2016 01:05:21 -0300
<sys/select.h> is required by POSIX.1-2001 to get the prototype of
select(2), but nearly no systems enforce that because older standards
let you get away with including some other headers. Recent OpenBSD
hacking has removed that frail touch of friendliness, however, which
broke some compiles; fix all the way back to 9.1 by adding the required
standard. Only vacuumdb.c was reported to fail, but it seems easier to
fix the whole lot in a fell swoop.
Per bug #14334 by Sean Farrell.
M src/backend/libpq/auth.c
M src/backend/postmaster/pgstat.c
M src/bin/pg_basebackup/pg_basebackup.c
M src/bin/pg_basebackup/pg_recvlogical.c
M src/bin/pg_basebackup/receivelog.c
M src/bin/pg_dump/parallel.c
M src/port/pgsleep.c
M src/test/examples/testlibpq2.c
Document has_type_privilege().
commit : 0b48e33403f7a85107dc9d319cccdba7e8ec1fe8
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 26 Sep 2016 11:50:35 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Mon, 26 Sep 2016 11:50:35 -0400
Evidently an oversight in commit 729205571. Back-patch to 9.2 where
privileges for types were introduced.
Report: <20160922173517.8214.88959@wrigleys.postgresql.org>
M doc/src/sgml/func.sgml
Install TAP test infrastructure so it's available for extension testing.
commit : 5d41f27a95878b0bb6ca7d737062424de0b20d8e
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 23 Sep 2016 15:50:00 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 23 Sep 2016 15:50:00 -0400
When configured with --enable-tap-tests, "make install" will now install
the Perl support files for TAP testing where PGXS will find them.
This allows extensions to rely on $(prove_check) even when being built
out-of-tree. Back-patch to 9.4 where we first started to support TAP
testing, to reduce the number of cases extension makefiles need to
consider.
Craig Ringer
Discussion: <CAMsr+YFXv+2qne6xJW7z_25mYBtktRX5rpkrgrb+DRgQ_FxgHQ@mail.gmail.com>
M src/Makefile
M src/test/Makefile
A src/test/perl/Makefile
Doc: fix examples of # operators so they actually work.
commit : 2cb1215be6205bbdd4f8ad9e43dcbcdbebedb686
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 23 Sep 2016 14:22:07 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 23 Sep 2016 14:22:07 -0400
These worked as-is until around 7.0, but fail in newer versions because
there are more operators named "#". Besides it's a bit inconsistent that
only two of the examples on this page lack type names on their constants.
Report: <20160923081530.1517.75670@wrigleys.postgresql.org>
M doc/src/sgml/func.sgml
Fix incorrect logic for excluding range constructor functions in pg_dump.
commit : 912ea194501a92adcd6defc7d24a3c263a82a58b
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 23 Sep 2016 13:49:27 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 23 Sep 2016 13:49:27 -0400
Faulty AND/OR nesting in the WHERE clause of getFuncs' SQL query led to
dumping range constructor functions if they are part of an extension
and we're in binary-upgrade mode. Actually, we don't want to dump them
separately even then, since CREATE TYPE AS RANGE will create the range's
constructor functions regardless. Per report from Andrew Dunstan.
It looks like this mistake was introduced by me, in commit b985d4877, in
perhaps-overzealous refactoring to reduce code duplication. I'm suitably
embarrassed.
Report: <34854939-02d7-f591-5677-ce2994104599@dunslane.net>
M src/bin/pg_dump/pg_dump.c
Don't trust CreateFileMapping() to clear the error code on success.
commit : b2d59ab02ce380daec0b974955d047eb74b0cebb
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 23 Sep 2016 10:09:52 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 23 Sep 2016 10:09:52 -0400
We must test GetLastError() even when CreateFileMapping() returns a
non-null handle. If that value were left over from some previous system
call, we might be fooled into thinking the segment already existed.
Experimentation on Windows 7 suggests that CreateFileMapping() clears
the error code on success, but it is not documented to do so, so let's
not rely on that happening in all Windows releases.
Amit Kapila
Discussion: <20811.1474390987@sss.pgh.pa.us>
M src/backend/storage/ipc/dsm_impl.c
Avoid using PostmasterRandom() for DSM control segment ID.
commit : 32cdf680f19a3c995da83cbef2741288b0549a7d
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 23 Sep 2016 09:54:11 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 23 Sep 2016 09:54:11 -0400
Commits 470d886c3 et al intended to fix the problem that the postmaster
selected the same "random" DSM control segment ID on every start. But
using PostmasterRandom() for that destroys the intended property that the
delay between random_start_time and random_stop_time will be unpredictable.
(Said delay is probably already more predictable than we could wish, but
that doesn't mean that reducing it by a couple orders of magnitude is OK.)
Revert the previous patch and add a comment warning against misuse of
PostmasterRandom. Fix the original problem by calling srandom() early in
PostmasterMain, using a low-security seed that will later be overwritten
by PostmasterRandom.
Discussion: <20789.1474390434@sss.pgh.pa.us>
M src/backend/postmaster/postmaster.c
M src/backend/storage/ipc/dsm.c
M src/include/postmaster/postmaster.h
Be sure to rewind the tuplestore read pointer in non-leader CTEScan nodes.
commit : d3dd00e675712da13262149b3478ecbff91525fd
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 22 Sep 2016 11:34:44 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 22 Sep 2016 11:34:44 -0400
ExecInitCteScan supposed that it didn't have to do anything to the extra
tuplestore read pointer it gets from tuplestore_alloc_read_pointer.
However, it needs this read pointer to be positioned at the start of the
tuplestore, while tuplestore_alloc_read_pointer is actually defined as
cloning the current position of read pointer 0. In normal situations
that accidentally works because we initialize the whole plan tree at once,
before anything gets read. But it fails in an EvalPlanQual recheck, as
illustrated in bug #14328 from Dima Pavlov. To fix, just forcibly rewind
the pointer after tuplestore_alloc_read_pointer. The cost of doing so is
negligible unless the tuplestore is already in TSS_READFILE state, which
wouldn't happen in normal cases. We could consider altering tuplestore's
API to make that case cheaper, but that would make for a more invasive
back-patch and it doesn't seem worth it.
This has been broken probably for as long as we've had CTEs, so back-patch
to all supported branches.
Discussion: <32468.1474548308@sss.pgh.pa.us>
M src/backend/executor/nodeCtescan.c
M src/test/isolation/expected/eval-plan-qual.out
M src/test/isolation/specs/eval-plan-qual.spec
Fix pgbench's calculation of average latency, when -T is not used.
commit : f16d4a241594bb198e1abedb5e43977ef796370a
author : Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Wed, 21 Sep 2016 13:14:48 +0300
committer: Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Wed, 21 Sep 2016 13:14:48 +0300
If the test duration was given in # of transactions (-t or no option),
rather as a duration (-T), the latency average was always printed as 0.
It has been broken ever since the display of latency average was added,
in 9.4.
Fabien Coelho
Discussion: <alpine.DEB.2.20.1607131015370.7486@sto>
M contrib/pgbench/pgbench.c
doc: Fix documentation to match actual make output
commit : 431a056271ff525661e85c781f817b3036c6e263
author : Peter Eisentraut <peter_e@gmx.net>
date : Tue, 20 Sep 2016 12:00:00 -0400
committer: Peter Eisentraut <peter_e@gmx.net>
date : Tue, 20 Sep 2016 12:00:00 -0400
based on patch from Takeshi Ideriha <iderihatakeshi@gmail.com>
M doc/src/sgml/installation.sgml
doc: Correct ALTER USER MAPPING example
commit : 4bac555ea260d2cc046e4e9f01ac61ad5bba1fdb
author : Peter Eisentraut <peter_e@gmx.net>
date : Tue, 20 Sep 2016 12:00:00 -0400
committer: Peter Eisentraut <peter_e@gmx.net>
date : Tue, 20 Sep 2016 12:00:00 -0400
The existing example threw an error.
From: gabrielle <gorthx@gmail.com>
M doc/src/sgml/ref/alter_user_mapping.sgml
Use PostmasterRandom(), not random(), for DSM control segment ID.
commit : 626312d1b3ee0c94f7ed685f751878d810ab53fc
author : Robert Haas <rhaas@postgresql.org>
date : Tue, 20 Sep 2016 12:24:44 -0400
committer: Robert Haas <rhaas@postgresql.org>
date : Tue, 20 Sep 2016 12:24:44 -0400
Otherwise, every startup gets the same "random" value, which is
definitely not what was intended.
M src/backend/postmaster/postmaster.c
M src/backend/storage/ipc/dsm.c
M src/include/postmaster/postmaster.h
Retry DSM control segment creation if Windows indicates access denied.
commit : c23b2523d3fcc09524e6720d7c2558ba1ee6c239
author : Robert Haas <rhaas@postgresql.org>
date : Tue, 20 Sep 2016 12:04:41 -0400
committer: Robert Haas <rhaas@postgresql.org>
date : Tue, 20 Sep 2016 12:04:41 -0400
Otherwise, attempts to run multiple postmasters running on the same
machine may fail, because Windows sometimes returns ERROR_ACCESS_DENIED
rather than ERROR_ALREADY_EXISTS when there is an existing segment.
Hitting this bug is much more likely because of another defect not
fixed by this patch, namely that dsm_postmaster_startup() uses
random() which returns the same value every time. But that's not
a reason not to fix this.
Kyotaro Horiguchi and Amit Kapila, reviewed by Michael Paquier
Discussion: <CAA4eK1JyNdMeF-dgrpHozDecpDfsRZUtpCi+1AbtuEkfG3YooQ@mail.gmail.com>
M src/backend/storage/ipc/dsm_impl.c
Fix latency calculation when there are \sleep commands in the script.
commit : 476945c451d675cc31cd89bce202b775cef45a8e
author : Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Mon, 19 Sep 2016 22:55:43 +0300
committer: Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Mon, 19 Sep 2016 22:55:43 +0300
We can't use txn_scheduled to hold the sleep-until time for \sleep, because
that interferes with calculation of the latency of the transaction as whole.
Backpatch to 9.4, where this bug was introduced.
Fabien COELHO
Discussion: <alpine.DEB.2.20.1608231622170.7102@lancre>
M contrib/pgbench/pgbench.c
MSVC: Include pg_recvlogical in client-only install.
commit : ca93b816f823d3be3088095832c44232738b6553
author : Robert Haas <rhaas@postgresql.org>
date : Mon, 19 Sep 2016 14:21:48 -0400
committer: Robert Haas <rhaas@postgresql.org>
date : Mon, 19 Sep 2016 14:21:48 -0400
MauMau, reviewed by Michael Paquier
M src/tools/msvc/Install.pm
Fix ecpg -? option on Windows, add -V alias for --version.
commit : d48e10a6859e2df81a43b1f830d42fa11c186a6f
author : Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Sun, 18 Sep 2016 13:46:32 +0300
committer: Heikki Linnakangas <heikki.linnakangas@iki.fi>
date : Sun, 18 Sep 2016 13:46:32 +0300
This makes the -? and -V options work consistently with other binaries.
--help and --version are now only recognized as the first option, i.e.
"ecpg --foobar --help" no longer prints the help, but that's consistent
with most of our other binaries, too.
Backpatch to all supported versions.
Haribabu Kommi
Discussion: <CAJrrPGfnRXvmCzxq6Dy=stAWebfNHxiL+Y_z7uqksZUCkW_waQ@mail.gmail.com>
M src/interfaces/ecpg/preproc/ecpg.c
pg_buffercache: Allow huge allocations.
commit : 1336bd9862c15db20a879f27082d18604fec7093
author : Robert Haas <rhaas@postgresql.org>
date : Thu, 15 Sep 2016 09:22:52 -0400
committer: Robert Haas <rhaas@postgresql.org>
date : Thu, 15 Sep 2016 09:22:52 -0400
Otherwise, users who have configured shared_buffers >= 256GB won't
be able to use this module. There probably aren't many of those, but
it doesn't hurt anything to fix it so that it works.
Backpatch to 9.4, where MemoryContextAllocHuge was introduced. The
same problem exists in older branches, but there's no easy way to
fix it there.
KaiGai Kohei
M contrib/pg_buffercache/pg_buffercache_pages.c
Fix copy/pasto in file identification
commit : 9410b711deafeec01672f213ec6b8383c137e759
author : Simon Riggs <simon@2ndQuadrant.com>
date : Mon, 12 Sep 2016 09:02:46 +0100
committer: Simon Riggs <simon@2ndQuadrant.com>
date : Mon, 12 Sep 2016 09:02:46 +0100
Daniel Gustafsson
M src/backend/storage/ipc/dsm_impl.c
Improve unreachability recognition in elog() macro.
commit : ebd971f74d8a20260bdb281977cfbd5404bfbb76
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 10 Sep 2016 17:54:23 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 10 Sep 2016 17:54:23 -0400
Some experimentation with an older version of gcc showed that it is able
to determine whether "if (elevel_ >= ERROR)" is compile-time constant
if elevel_ is declared "const", but otherwise not so much. We had
accounted for that in ereport() but were too miserly with braces to
make it so in elog(). I don't know how many currently-interesting
compilers have the same quirk, but in case it will save some code
space, let's make sure that elog() is on the same footing as ereport()
for this purpose.
Back-patch to 9.3 where we introduced pg_unreachable() calls into
elog/ereport.
M src/include/utils/elog.h
Fix miserable coding in pg_stat_get_activity().
commit : fb7ed3889fa6fc0f4aa6718ffb6574801ad12484
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 10 Sep 2016 13:49:04 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 10 Sep 2016 13:49:04 -0400
Commit dd1a3bccc replaced a test on whether a subroutine returned a
null pointer with a test on whether &pointer->backendStatus was null.
This accidentally failed to fail, at least on common compilers, because
backendStatus is the first field in the struct; but it was surely trouble
waiting to happen. Commit f91feba87 then messed things up further,
changing the logic to
local_beentry = pgstat_fetch_stat_local_beentry(curr_backend);
if (!local_beentry)
continue;
beentry = &local_beentry->backendStatus;
if (!beentry)
{
where the second "if" is now dead code, so that the intended behavior of
printing a row with "<backend information not available>" cannot occur.
I suspect this is all moot because pgstat_fetch_stat_local_beentry
will never actually return null in this function's usage, but it's still
very poor coding. Repair back to 9.4 where the original problem was
introduced.
M src/backend/utils/adt/pgstatfuncs.c
Fix locking a tuple updated by an aborted (sub)transaction
commit : 8778da2af0f4dac23b8d1ef3436b6bb0954bc013
author : Alvaro Herrera <alvherre@alvh.no-ip.org>
date : Fri, 9 Sep 2016 15:54:29 -0300
committer: Alvaro Herrera <alvherre@alvh.no-ip.org>
date : Fri, 9 Sep 2016 15:54:29 -0300
When heap_lock_tuple decides to follow the update chain, it tried to
also lock any version of the tuple that was created by an update that
was subsequently rolled back. This is pointless, since for all intents
and purposes that tuple exists no more; and moreover it causes
misbehavior, as reported independently by Marko Tiikkaja and Marti
Raudsepp: some SELECT FOR UPDATE/SHARE queries may fail to return
the tuples, and assertion-enabled builds crash.
Fix by having heap_lock_updated_tuple test the xmin and return success
immediately if the tuple was created by an aborted transaction.
The condition where tuples become invisible occurs when an updated tuple
chain is followed by heap_lock_updated_tuple, which reports the problem
as HeapTupleSelfUpdated to its caller heap_lock_tuple, which in turn
propagates that code outwards possibly leading the calling code
(ExecLockRows) to believe that the tuple exists no longer.
Backpatch to 9.3. Only on 9.5 and newer this leads to a visible
failure, because of commit 27846f02c176; before that, heap_lock_tuple
skips the whole dance when the tuple is already locked by the same
transaction, because of the ancient HeapTupleSatisfiesUpdate behavior.
Still, the buggy condition may also exist in more convoluted scenarios
involving concurrent transactions, so it seems safer to fix the bug in
the old branches too.
Discussion:
https://www.postgresql.org/message-id/CABRT9RC81YUf1=jsmWopcKJEro=VoeG2ou6sPwyOUTx_qteRsg@mail.gmail.com
https://www.postgresql.org/message-id/48d3eade-98d3-8b9a-477e-1a8dc32a724d@joh.to
M src/backend/access/heap/heapam.c
M src/test/regress/expected/combocid.out
M src/test/regress/sql/combocid.sql
Fix VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL
commit : 81b0f820472dac93759d21dc8775fa588f473005
author : Simon Riggs <simon@2ndQuadrant.com>
date : Fri, 9 Sep 2016 11:44:54 +0100
committer: Simon Riggs <simon@2ndQuadrant.com>
date : Fri, 9 Sep 2016 11:44:54 +0100
lazy_truncate_heap() was waiting for
VACUUM_TRUNCATE_LOCK_WAIT_INTERVAL, but in microseconds
not milliseconds as originally intended.
Found by code inspection.
Simon Riggs
M src/backend/commands/vacuumlazy.c
Fix mdtruncate() to close fd.c handle of deleted segments.
commit : 075cfbe4a966aa9717941ac8dce48434c4706aa5
author : Andres Freund <andres@anarazel.de>
date : Thu, 8 Sep 2016 16:51:09 -0700
committer: Andres Freund <andres@anarazel.de>
date : Thu, 8 Sep 2016 16:51:09 -0700
mdtruncate() forgot to FileClose() a segment's mdfd_vfd, when deleting
it. That lead to a fd.c handle to a truncated file being kept open until
backend exit.
The issue appears to have been introduced way back in 1a5c450f3024ac5,
before that the handle was closed inside FileUnlink().
The impact of this bug is limited - only VACUUM and ON COMMIT TRUNCATE
for temporary tables, truncate files in place (i.e. TRUNCATE itself is
not affected), and the relation has to be bigger than 1GB. The
consequences of a leaked fd.c handle aren't severe either.
Discussion: <20160908220748.oqh37ukwqqncbl3n@alap3.anarazel.de>
Backpatch: all supported releases
M src/backend/storage/smgr/md.c
Doc: small improvements for documentation about VACUUM freezing.
commit : db88112ce17f05b211cf6e2c50f1dd7107556786
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Tue, 6 Sep 2016 17:50:53 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Tue, 6 Sep 2016 17:50:53 -0400
Mostly, explain how row xmin's used to be replaced by FrozenTransactionId
and no longer are. Do a little copy-editing on the side.
Per discussion with Egor Rogov. Back-patch to 9.4 where the behavioral
change occurred.
Discussion: <575D7955.6060209@postgrespro.ru>
M doc/src/sgml/maintenance.sgml
Add regression test coverage for non-default timezone abbreviation sets.
commit : c8d2bd4e43914f0101e8b6ab53f45520eea13039
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Sun, 4 Sep 2016 20:02:16 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Sun, 4 Sep 2016 20:02:16 -0400
After further reflection about the mess cleaned up in commit 39b691f25,
I decided the main bit of test coverage that was still missing was to
check that the non-default abbreviation-set files we supply are usable.
Add that.
Back-patch to supported branches, just because it seems like a good
idea to keep this all in sync.
M src/test/regress/expected/timestamptz.out
M src/test/regress/sql/timestamptz.sql
M src/timezone/README
Remove vestigial references to "zic" in favor of "IANA database".
commit : 0397fbaa67213647b65e5f8b50987f9b4eb22a43
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Sun, 4 Sep 2016 19:42:08 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Sun, 4 Sep 2016 19:42:08 -0400
Commit b2cbced9e instituted a policy of referring to the timezone database
as the "IANA timezone database" in our user-facing documentation.
Propagate that wording into a couple of places that were still using "zic"
to refer to the database, which is definitely not right (zic is the
compilation tool, not the data).
Back-patch, not because this is very important in itself, but because
we routinely cherry-pick updates to the tznames files and I don't want
to risk future merge failures.
M src/timezone/tznames/Africa.txt
M src/timezone/tznames/America.txt
M src/timezone/tznames/Asia.txt
M src/timezone/tznames/Australia
M src/timezone/tznames/Australia.txt
M src/timezone/tznames/Default
M src/timezone/tznames/Etc.txt
M src/timezone/tznames/Europe.txt
M src/timezone/tznames/Pacific.txt
M src/tools/RELEASE_CHANGES
Fix corrupt GIN_SEGMENT_ADDITEMS WAL records on big-endian hardware.
commit : a694435641faf26a9a4c210d20576ae836e86c48
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 3 Sep 2016 13:28:53 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Sat, 3 Sep 2016 13:28:53 -0400
computeLeafRecompressWALData() tried to produce a uint16 WAL log field by
memcpy'ing the first two bytes of an int-sized variable. That accidentally
works on little-endian hardware, but not at all on big-endian. Replay then
thinks it's looking at an ADDITEMS action with zero entries, and reads the
first two bytes of the first TID therein as the next segno/action,
typically leading to "unexpected GIN leaf action" errors during replay.
Even if replay failed to crash, the resulting GIN index page would surely
be incorrect. To fix, just declare the variable as uint16 instead.
Per bug #14295 from Spencer Thomason (much thanks to Spencer for turning
his problem into a self-contained test case). This likely also explains
a previous report of the same symptom from Bernd Helmle.
Back-patch to 9.4 where the problem was introduced (by commit 14d02f0bb).
Discussion: <20160826072658.15676.7628@wrigleys.postgresql.org>
Possible-Report: <2DA7350F7296B2A142272901@eje.land.credativ.lan>
M src/backend/access/gin/gindatapage.c
Don't require dynamic timezone abbreviations to match underlying time zone.
commit : 7430ac852eb9795c708e5b2e105c253328e3d571
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 2 Sep 2016 17:29:32 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 2 Sep 2016 17:29:32 -0400
Previously, we threw an error if a dynamic timezone abbreviation did not
match any abbreviation recorded in the referenced IANA time zone entry.
That seemed like a good consistency check at the time, but it turns out
that a number of the abbreviations in the IANA database are things that
Olson and crew made up out of whole cloth. Their current policy is to
remove such names in favor of using simple numeric offsets. Perhaps
unsurprisingly, a lot of these made-up abbreviations have varied in meaning
over time, which meant that our commit b2cbced9e and later changes made
them into dynamic abbreviations. So with newer IANA database versions
that don't mention these abbreviations at all, we fail, as reported in bug
#14307 from Neil Anderson. It's worse than just a few unused-in-the-wild
abbreviations not working, because the pg_timezone_abbrevs view stops
working altogether (since its underlying function tries to compute the
whole view result in one call).
We considered deleting these abbreviations from our abbreviations list, but
the problem with that is that we can't stay ahead of possible future IANA
changes. Instead, let's leave the abbreviations list alone, and treat any
"orphaned" dynamic abbreviation as just meaning the referenced time zone.
It will behave a bit differently than it used to, in that you can't any
longer override the zone's standard vs. daylight rule by using the "wrong"
abbreviation of a pair, but that's better than failing entirely. (Also,
this solution can be interpreted as adding a small new feature, which is
that any abbreviation a user wants can be defined as referencing a time
zone name.)
Back-patch to all supported branches, since this problem affects all
of them when using tzdata 2016f or newer.
Report: <20160902031551.15674.67337@wrigleys.postgresql.org>
Discussion: <6189.1472820913@sss.pgh.pa.us>
M doc/src/sgml/catalogs.sgml
M doc/src/sgml/datetime.sgml
M src/backend/utils/adt/datetime.c
M src/test/regress/expected/timestamptz.out
M src/test/regress/sql/timestamptz.sql
Suppress GCC 6 warning about self-comparison
commit : 1efc1ea10f284264e2555c4d182abd82ca3575e3
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 1 Sep 2016 12:48:06 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 1 Sep 2016 12:48:06 -0400
Back-patch commit a2fd62dd53fb606dee69e0f4eb12289c87f5c8b1
into older branches. Per complaint from Pavel Stehule.
M src/port/path.c
Fix minor 9.4-only bug in logical decoding.
commit : 10ad15f48ab187d754d657892d2f65695a7adea6
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 1 Sep 2016 11:45:16 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 1 Sep 2016 11:45:16 -0400
The 9.4 version of log_heap_update() stores the full length of the
old_key_tuple in xlhdr.t_len, rather than the length less
offsetof(HeapTupleHeaderData, t_bits) as is customary elsewhere.
DecodeUpdate() was expecting the usual definition, which caused it
to copy 23 bytes too much out of the WAL-file buffer. Most of the
time that's harmless, although Valgrind on buildfarm member skink
has been complaining about it, and there was one actual SIGSEGV
on curculio that might have been caused by this. The reconstructed
key tuple would also have an over-length t_len, though offhand
I do not see how that could cause any visible problem.
The problem seems to have disappeared in the 9.5 WAL format changes
(commit 2c03216d8), so we only need to fix 9.4.
Discussion: <11035.1469058247@sss.pgh.pa.us>
M src/backend/replication/logical/decode.c
Prevent starting a standalone backend with standby_mode on.
commit : f4e40537e1ea3b9c620cb80da97dc56eb088fc4b
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 31 Aug 2016 08:52:13 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 31 Aug 2016 08:52:13 -0400
This can't really work because standby_mode expects there to be more
WAL arriving, which there will not ever be because there's no WAL
receiver process to fetch it. Moreover, if standby_mode is on then
hot standby might also be turned on, causing even more strangeness
because that expects read-only sessions to be executing in parallel.
Bernd Helmle reported a case where btree_xlog_delete_get_latestRemovedXid
got confused, but rather than band-aiding individual problems it seems
best to prevent getting anywhere near this state in the first place.
Back-patch to all supported branches.
In passing, also fix some omissions of errcodes in other ereport's in
readRecoveryCommandFile().
Michael Paquier (errcode hacking by me)
Discussion: <00F0B2CEF6D0CEF8A90119D4@eje.credativ.lan>
M src/backend/access/transam/xlog.c
Fix pg_xlogdump so that it handles cross-page XLP_FIRST_IS_CONTRECORD record.
commit : 314a25fb3ae3ae2fc6007fd39ff01da7558565a4
author : Fujii Masao <fujii@postgresql.org>
date : Mon, 29 Aug 2016 14:34:58 +0900
committer: Fujii Masao <fujii@postgresql.org>
date : Mon, 29 Aug 2016 14:34:58 +0900
Previously pg_xlogdump failed to dump the contents of the WAL file
if the file starts with the continuation WAL record which spans
more than one pages. Since pg_xlogdump assumed that the continuation
record always fits on a page, it could not find the valid WAL record to
start reading from in that case.
This patch changes pg_xlogdump so that it can handle a continuation
WAL record which crosses a page boundary and find the valid record
to start reading from.
Back-patch to 9.3 where pg_xlogdump was introduced.
Author: Pavan Deolasee
Reviewed-By: Michael Paquier and Craig Ringer
Discussion: CABOikdPsPByMiG6J01DKq6om2+BNkxHTPkOyqHM2a4oYwGKsqQ@mail.gmail.com
M src/backend/access/transam/xlogreader.c
Fix instability in parallel regression tests.
commit : 5b79dd6eddeecc656ecf5fd85a61a2a3fa170efa
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 25 Aug 2016 09:57:09 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 25 Aug 2016 09:57:09 -0400
Commit f0c7b789a added a test case in case.sql that creates and then drops
both an '=' operator and the type it's for. Given the right timing, that
can cause a "cache lookup failed for type" failure in concurrent sessions,
which see the '=' operator as a potential match for '=' in a query, but
then the type is gone by the time they inquire into its properties.
It might be nice to make that behavior more robust someday, but as a
back-patchable solution, adjust the new test case so that the operator
is never visible to other sessions. Like the previous commit, back-patch
to all supported branches.
Discussion: <5983.1471371667@sss.pgh.pa.us>
M src/test/regress/expected/case.out
M src/test/regress/sql/case.sql
Fix small query-lifespan memory leak in bulk updates.
commit : 566afa15c8dc64430dfb1e95c661e5875863253c
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 24 Aug 2016 22:20:01 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 24 Aug 2016 22:20:01 -0400
When there is an identifiable REPLICA IDENTITY index on the target table,
heap_update leaks the id_attrs bitmapset. That's not many bytes, but it
adds up over enough rows, since the code typically runs in a query-lifespan
context. Bug introduced in commit e55704d8b, which did a rather poor job
of cloning the existing use-pattern for RelationGetIndexAttrBitmap().
Per bug #14293 from Zhou Digoal. Back-patch to 9.4 where the bug was
introduced.
Report: <20160824114320.15676.45171@wrigleys.postgresql.org>
M src/backend/access/heap/heapam.c
Fix improper repetition of previous results from a hashed aggregate.
commit : 08a823e53b78507c9fcc8a6d77de1a1d5b7c1b13
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 24 Aug 2016 14:37:51 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 24 Aug 2016 14:37:51 -0400
ExecReScanAgg's check for whether it could re-use a previously calculated
hashtable neglected the possibility that the Agg node might reference
PARAM_EXEC Params that are not referenced by its input plan node. That's
okay if the Params are in upper tlist or qual expressions; but if one
appears in aggregate input expressions, then the hashtable contents need
to be recomputed when the Param's value changes.
To avoid unnecessary performance degradation in the case of a Param that
isn't within an aggregate input, add logic to the planner to determine
which Params are within aggregate inputs. This requires a new field in
struct Agg, but fortunately we never write plans to disk, so this isn't
an initdb-forcing change.
Per report from Jeevan Chalke. This has been broken since forever,
so back-patch to all supported branches.
Andrew Gierth, with minor adjustments by me
Report: <CAM2+6=VY8ykfLT5Q8vb9B6EbeBk-NGuLbT6seaQ+Fq4zXvrDcA@mail.gmail.com>
M src/backend/executor/nodeAgg.c
M src/backend/nodes/copyfuncs.c
M src/backend/nodes/outfuncs.c
M src/backend/optimizer/plan/createplan.c
M src/backend/optimizer/plan/subselect.c
M src/include/nodes/plannodes.h
M src/test/regress/expected/aggregates.out
M src/test/regress/sql/aggregates.sql
reorderbuffer: preserve errno while reporting error
commit : 07d47231fbc57ac8e84ac1bd5cdf2e7e1966a45f
author : Alvaro Herrera <alvherre@alvh.no-ip.org>
date : Fri, 19 Aug 2016 14:38:55 -0300
committer: Alvaro Herrera <alvherre@alvh.no-ip.org>
date : Fri, 19 Aug 2016 14:38:55 -0300
Clobbering errno during cleanup after an error is an oft-repeated, easy
to make mistake. Deal with it here as everywhere else, by saving it
aside and restoring after cleanup, before ereport'ing.
In passing, add a missing errcode declaration in another ereport() call
in the same file, which I noticed while skimming the file looking for
similar problems.
Backpatch to 9.4, where this code was introduced.
M src/backend/replication/logical/reorderbuffer.c
Update Windows timezone mapping from Windows 7 and 10
commit : 1d990cd8c41c3678341250cc77c190d6bcd2d21f
author : Magnus Hagander <magnus@hagander.net>
date : Thu, 18 Aug 2016 12:32:42 +0200
committer: Magnus Hagander <magnus@hagander.net>
date : Thu, 18 Aug 2016 12:32:42 +0200
This adds a couple of new timezones that are present in the newer
versions of Windows. It also updates comments to reference UTC rather
than GMT, as this change has been made in Windows.
Michael Paquier
M src/bin/initdb/findtimezone.c
Properly re-initialize replication slot shared memory upon creation.
commit : 690a2fb90ef47a3a0750b70e2abf13bbb82466ff
author : Andres Freund <andres@anarazel.de>
date : Wed, 17 Aug 2016 13:15:04 -0700
committer: Andres Freund <andres@anarazel.de>
date : Wed, 17 Aug 2016 13:15:04 -0700
Slot creation did not clear all fields upon creation. After start the
memory is zeroed, but when a physical replication slot was created in
the shared memory of a previously existing logical slot, catalog_xmin
would not be cleared. That in turn would prevent vacuum from doing its
duties.
To fix initialize all the fields. To make similar future bugs less
likely, zero all of ReplicationSlotPersistentData, and re-order the
rest of the initialization to be in struct member order.
Analysis: Andrew Gierth
Reported-By: md@chewy.com
Author: Michael Paquier
Discussion: <20160705173502.1398.70934@wrigleys.postgresql.org>
Backpatch: 9.4, where replication slots were introduced
M src/backend/replication/slot.c
Fix -e option in contrib/intarray/bench/bench.pl.
commit : 3fa8ec44d1b95a7ee16a43e32d2bebcdd8b54a77
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 17 Aug 2016 15:51:10 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 17 Aug 2016 15:51:10 -0400
As implemented, -e ran an EXPLAIN but then discarded the output, which
certainly seems pointless. Make it print to stdout instead. It's been
like that forever, so back-patch to all supported branches.
Daniel Gustafsson, reviewed by Andreas Scherbaum
Patch: <B97BDCB7-A3B3-4734-90B5-EDD586941629@yesql.se>
M contrib/intarray/bench/bench.pl
Fix assorted places in psql to print version numbers >= 10 in new style.
commit : 6d1dc2afbd5536e39977343c7e11b6954c9ceaf8
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Tue, 16 Aug 2016 15:58:31 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Tue, 16 Aug 2016 15:58:31 -0400
This is somewhat cosmetic, since as long as you know what you are looking
at, "10.0" is a serviceable substitute for "10". But there is a potential
for confusion between version numbers with minor numbers and those without
--- we don't want people asking "why is psql saying 10.0 when my server is
10.2". Therefore, back-patch as far as practical, which turns out to be
9.3. I could have redone the patch to use fprintf(stderr) in place of
psql_error(), but it seems more work than is warranted for branches that
will be EOL or nearly so by the time v10 comes out.
Although only psql seems to contain any code that needs this, I chose
to put the support function into fe_utils, since it seems likely we'll
need it in other client programs in future. (In 9.3-9.5, use dumputils.c,
the predecessor of fe_utils/string_utils.c.)
In HEAD, also fix the backend code that whines about loadable-library
version mismatch. I don't see much need to back-patch that.
M src/bin/pg_dump/dumputils.c
M src/bin/pg_dump/dumputils.h
M src/bin/psql/command.c
M src/bin/psql/common.c
M src/bin/psql/describe.c
Remove bogus dependencies on NUMERIC_MAX_PRECISION.
commit : 4ac3d779477fbb08799c70348e1e6f8c9046e187
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Sun, 14 Aug 2016 15:06:01 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Sun, 14 Aug 2016 15:06:01 -0400
NUMERIC_MAX_PRECISION is a purely arbitrary constraint on the precision
and scale you can write in a numeric typmod. It might once have had
something to do with the allowed range of a typmod-less numeric value,
but at least since 9.1 we've allowed, and documented that we allowed,
any value that would physically fit in the numeric storage format;
which is something over 100000 decimal digits, not 1000.
Hence, get rid of numeric_in()'s use of NUMERIC_MAX_PRECISION as a limit
on the allowed range of the exponent in scientific-format input. That was
especially silly in view of the fact that you can enter larger numbers as
long as you don't use 'e' to do it. Just constrain the value enough to
avoid localized overflow, and let make_result be the final arbiter of what
is too large. Likewise adjust ecpg's equivalent of this code.
Also get rid of numeric_recv()'s use of NUMERIC_MAX_PRECISION to limit the
number of base-NBASE digits it would accept. That created a dump/restore
hazard for binary COPY without doing anything useful; the wire-format
limit on number of digits (65535) is about as tight as we would want.
In HEAD, also get rid of pg_size_bytes()'s unnecessary intimacy with what
the numeric range limit is. That code doesn't exist in the back branches.
Per gripe from Aravind Kumar. Back-patch to all supported branches,
since they all contain the documentation claim about allowed range of
NUMERIC (cf commit cabf5d84b).
Discussion: <2895.1471195721@sss.pgh.pa.us>
M src/backend/utils/adt/numeric.c
M src/include/utils/numeric.h
M src/interfaces/ecpg/pgtypeslib/numeric.c
Fix inappropriate printing of never-measured times in EXPLAIN.
commit : 85974b468a17614b4654fc7dc12a42b17cc2fda7
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 12 Aug 2016 12:13:04 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Fri, 12 Aug 2016 12:13:04 -0400
EXPLAIN (ANALYZE, TIMING OFF) would print an elapsed time of zero for
a trigger function, because no measurement has been taken but it printed
the field anyway. This isn't what EXPLAIN does elsewhere, so suppress it.
In the same vein, EXPLAIN (ANALYZE, BUFFERS) with non-text output format
would print buffer I/O timing numbers even when no measurement has been
taken because track_io_timing is off. That seems not per policy, either,
so change it.
Back-patch to 9.2 where these features were introduced.
Maksim Milyutin
Discussion: <081c0540-ecaa-bd29-3fd2-6358f3b359a9@postgrespro.ru>
M src/backend/commands/explain.c
Fix busted Assert for CREATE MATVIEW ... WITH NO DATA.
commit : 268d92e5336d25b296a5ccf8ccf803a2adb40251
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 11 Aug 2016 11:22:25 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Thu, 11 Aug 2016 11:22:25 -0400
Commit 874fe3aea changed the command tag returned for CREATE MATVIEW/CREATE
TABLE AS ... WITH NO DATA, but missed that there was code in spi.c that
expected the command tag to always be "SELECT". Fortunately, the
consequence was only an Assert failure, so this oversight should have no
impact in production builds.
Since this code path was evidently un-exercised, add a regression test.
Per report from Shivam Saxena. Back-patch to 9.3, like the previous commit.
Michael Paquier
Report: <97218716-480B-4527-B5CD-D08D798A0C7B@dresources.com>
M src/backend/executor/spi.c
M src/test/regress/expected/matview.out
M src/test/regress/sql/matview.sql
Doc: write some for adminpack.
commit : 042b6beeeb17ec34ea0764921574f2d8a2761472
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 10 Aug 2016 21:39:50 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Wed, 10 Aug 2016 21:39:50 -0400
Previous contents of adminpack.sgml were rather far short of project norms.
Not to mention being outright wrong about the signature of pg_file_read().
M doc/src/sgml/adminpack.sgml
Fix typo
commit : 55a3a6e3c179c22ec09f2ae43869ebca32e5a278
author : Peter Eisentraut <peter_e@gmx.net>
date : Tue, 9 Aug 2016 19:07:24 -0400
committer: Peter Eisentraut <peter_e@gmx.net>
date : Tue, 9 Aug 2016 19:07:24 -0400
M contrib/pgcrypto/px.c
Doc: clarify description of CREATE/ALTER FUNCTION ... SET FROM CURRENT.
commit : 86c40464b9cfe8de6135fdfd2b5b7b9bd6f6cb2b
author : Tom Lane <tgl@sss.pgh.pa.us>
date : Tue, 9 Aug 2016 13:39:24 -0400
committer: Tom Lane <tgl@sss.pgh.pa.us>
date : Tue, 9 Aug 2016 13:39:24 -0400
Per discussion with David Johnston.
M doc/src/sgml/ref/alter_function.sgml
M doc/src/sgml/ref/create_function.sgml