Fix planner statistics and manages query plans

Fork

Change version to 1.5.0

Preparation for release.

Add .bc to .gitignore

Do not let installation script replace existing SQL functions

The installation script created some functions using CREATE OR REPLACE
FUNCTION. That command replaces function body but doesn't fix
ownership, which leads to a security issue that allows attacker to run
arbitrary script with elevated privileges. Let installation script
rather error-out in that case.

Reported by Egashira Yusuke.

Correct extension version.

pg_dbms_stats.control had a wrong version name that prevents the
installation script from being found. Fixed it.

Make installation script more secure.

Recently, PostgreSQL introduced a security enhancement related to
"trusted extensions". pg_dbms_stats is not a trusted extension, but it
is always important that installation scripts are resistant to
maliciously crafted environment. This commit makes all references to
system objects fully-qualified to achieve the robustness.

Reported by Egashira Yusuke.

Fix SPEC file.

Fix spec file so that llvmjit packages is available.

1.5.0 beta 1, Support PostgreSQL 13

Supports PostgreSQL 13.

- Follow API change of planner_hook.
- Remove useless code.
- Adjust regression tests.
- Disable one test item no longer doable.

Suppoert PostgreSQL 12, version 1.4.0.

Support PostgreSQL 12. pg_statisitc has new columns so the amount of
the changes of code and test scripts are so large that I decidec to
diverge this version from that for older PG versions, which have gone
to the branch PRE_12.

Change version to 3.9.11

Fix a crash bug related to non-baserel RTEs and function indexes

dbms_stats_get_index_stats forgot that simple_rel_array may have empty
slots corresponding to non-baserel RTEs. Server crashes when saved
statitistics for function indexes are accessed while planning such a
query. This is fixed by simply skipping such entries.

Disalbe autovacuum during regression test

Autovacuum is one of the sources of unstability of regression
test. This patch turn it off during regression test.

Move a test item because of a change of an error message

One error messages has been changed replacing the word 'relation' with
'table' and this hits the ut-common test case. Moved the test case
into ut-<version> files.

Support PG11.

Follow the changes of some core functions.

Fix calling parameter of SPI_execute_plan

Fixed a long-standing bug but having done no harm over all existing
versions. SPI_execute_plan's third paramter is char [] but it is
called with bool []. The bool value is false and it is different from
'n', which represents !is_null so it has been worked as expected as the
result.

Bumped up version to 1.3.10

Bumped up version to 1.3.10

Change copyright year of files

Change copyright year up to 2018.

Add description that it is obsolete in ChangeLog files

ChangeLog files have not maintained for a long time. The same
information is seen in commit logs nowadays. First add that
description to the files, then remove them later.

Remove support for PG9.2

PostgreSQL 9.2 have reached EOL. Remove support for the version.

Fix relcache invalidation handling

Relcache invalidation callback can be called at every chance while
planning. Planner can crash if the invalidation callblack frees
statistics cache that have been passed to planner. This patch let
pg_dbms_stats refrain from freeing statistics cache immediately by
relcache invalidation. Invalidated cache entries are removed before
and after planner runs.

Add English document.

Added a set of English version of the document based on the
just-revised Japanese docuemnt.

Edit Japanese documents.

Make it up to date, fixed some wrong descriptions and removed some
items with less importance.

Make pg_dbms_stats workable for PG11

This commit let it follow to the cahnges on the master HEAD and rig
with a complete set of subsidiary files.

Update spec files for 1.3.9 release.

Update rpm spec files for 1.3.9 release.

Properly set privilege information to VariableStatData

As the fix for CVE-2017-7484, VariableStatData is required to be set
acl_ok properly and the locked stats will not be in effect if not. As
the result, pg_dbms_stats 1.3.8 doesn't work for the minor versions
since 9.2.21, 9.3.17, 9.4.12, 9.5.7 and 9.6.3. PG10 behaves so from
the first version. This commit fixes that.

The binaries built for the fixed versions can be loaded and work fine
on all minor versions containing pre-fixed versions, but the binaries
built for the pre-fixed versions still has the problem

The regression test was missing whether locked stats is 'actually
applied or not. The test items for the case is added.

The version is updated to 1.3.9.

Fix a misspelling in regression test

Version bumped up to 1.3.8.

Mainly for management reasons, version of pg_dbms_stats bumped up to
1.3.8. Since no functional changes has taken place, the change is made
only for the PostgreSQL 10 build. Other builds will be bumped up in
the future releases if any.

Prevent regtest being affected by autovacuum

The result of a test query in ut-common can contain an excessive
output caused by autovacuum. Excluded it to prevent regtest from
being disturbed.

Prepare RPM package build environment for Pg10

Added a spec file. Edited Makefile so that tar ball contains required
files for Pg10 version of pg_dbms_stats.

Add --build-id flag mandatory for RPM package build

Set flags for ld mandated by rpmbuild.

Drop support for PostgreSQL 9.1

9.1 has already been out of support so pg_dbms_stats will no longer be
updated for the PostgreSQL version. Several files and many branches in
C code required to support the version are removed by this commit.