Fix planner statistics and manages query plans

Fork

Change version to 1.4.1.

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.

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.

Change version to 1.3.12.

Do not replace existing function by installation script

The installation script created some functions using CREATE OR REPLACE
FUNCTION. Those commands replace function body but don't fix
ownership, which leads to a security issue if those functions are
maliciously crafted by an attacker. Just ripping-off "OR REPLACE"
prevents that issue by causing an error for that case.

Reported by Egashira Yusuke.

Add .bc file to .gitignore

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.

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.

Fix spec file

Fix SPEC file so that llvmjit package is created.

Fix project URL

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.

Fix package dependency

Fixed dependency definition of RPM SPEC file.

Add release for PG11

I forgot to release 1.3.11 for PG11. This is that.

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.