486 Commits

Author SHA1 Message Date
29efa50846
Merge branch 'master' of https://github.com/reorg/pg_repack 2018-08-03 21:34:32 +04:30
66fa28ee8f
Remove unnecessary message 2018-08-03 11:54:57 +04:30
Daniele Varrazzo
705f216fcf Fixed docs generation with recent docutils 2018-06-17 21:00:05 +01:00
Masahiko Sawada
1439ee2db5
Merge pull request #180 from MasahikoSawada/jp_doc_1_4_3
Update Japanese doc for pg_repack 1.4.3 release.
2018-05-23 15:21:54 +09:00
Masahiko Sawada
88fe6bfa9c Update Japanese doc for pg_repack 1.4.3 release. 2018-05-22 10:03:27 +09:00
Daniele Varrazzo
f4e010386a Preparing release 1.4.3 2018-05-19 17:27:49 +01:00
Daniele Varrazzo
4401bcf804 Merge branch 'fix-search-path' 2018-05-19 17:13:08 +01:00
Daniele Varrazzo
021d0b0393 Fixed broken library paths on recent ubuntu packages
Close #179
2018-05-19 17:12:39 +01:00
Daniele Varrazzo
9c1da1bff1 Fixed tests to match info messages including the public schema 2018-05-19 16:41:56 +01:00
Masahiko Sawada
64cc2070ed Fix the broken behavior made by restricting the search path
This commit doesn't include the change of regression test files.
2018-04-06 14:50:40 +09:00
Josh Kupershmidt
02e6c5ce96
Merge pull request #166 from bashtanov/fix_lockup
Avoid excessive locking when table already being repacked by another instance
2018-03-21 14:35:33 -04:00
Daniele Varrazzo
914537edc7 An attempt to restrict the search path to avoid injections
An alternative way to fix #168 which is not as invasive as the changes
in #171.

This currently breaks the current behaviour of the program as the tables
specified on command line are not found.
2018-03-20 20:47:06 +00:00
Daniele Varrazzo
ce8e283f63 Merge branch 'clean-tests' 2018-03-20 12:56:25 +00:00
Daniele Varrazzo
73851d2e5c Test file separated in setup - run - check
The run part has different output across minor versions, the others not.

Dropped test files identification statement as now the variable part is
in small chunks.
2018-03-20 12:49:15 +00:00
Daniele Varrazzo
74d56ef4d6 Dropped now equivalent test output files 2018-03-20 12:31:39 +00:00
Daniele Varrazzo
a5509c7415 No superuser check separated from other tests
The output differs across versions because it can include the context.

This made:

- repack.out = repack_1.out
- repack_3.out = repack_5.out
2018-03-20 12:29:16 +00:00
Daniele Varrazzo
6dfbfffe59 Dropped duplicate test output files 2018-03-20 12:20:06 +00:00
Daniele Varrazzo
0cb08e5512 Variable psql table output moved in separate file
This made:

- repack.out == repack_2.out
- repack_3.out == repack_4.out
- repack_1.out == repack_6.out
2018-03-20 11:39:41 +00:00
Daniele Varrazzo
31d15a87e7 Merge branch 'schema_qualified' 2018-03-19 19:47:23 +00:00
Daniele Varrazzo
c62d865c18 Choose schema name visibility from running server version
Guarantee the extension compiled on newer servers can be used on older
ones.
2018-03-19 19:41:46 +00:00
Daniele Varrazzo
07e944d9d1 Use the Postgres way to get the version number
Unsurprisingly, there was one.
2018-03-19 19:07:33 +00:00
Daniele Varrazzo
e499d3df10 Merge branch 'schema_qualified' 2018-03-09 16:13:51 +00:00
Daniele Varrazzo
2fd0eb050a A more compact way to verify the identity of the test files 2018-03-09 15:32:26 +00:00
Masahiko Sawada
64c22ffc5f Add expected files for regression tests.
Due to compatibility break by the recent PostgreSQL core code changes
we need to split expected files into each minor releases rather than
each major releases.

Now the mapping between PostgreSQL version and expected file is
complicated as follows.

* version 10
  * >= 10.3 : repack_3.out, tablespace_2.out
  * < 10.3 : repack_2.out, tablespace.out

* version 9.6
  * >= 9.6.8 : repack_4.out, tablespace_2.out
  * < 9.6.8 : repack.out, tablespace.out

* version 9.5
  * >= 9.5.12 : repack_4.out, tablespace_2.out
  * < 9.5.12 : repack.out, tablespace_1.out

* version 9.4
  * >= 9.4.17 : repack_5.out, tablespace_2.out
  * < 9.4.17 : repack_1.out, tablespace_1.out

* version 9.3
  * >= 9.3.22 : repack_6.out, tablespace_3.out
  * < 9.3.22 : repack_1.out, tablespace_1.out

* version 9.2 : repack_1.out, tablespace_1.out

* version 9.1 : repack_1.out, tablespace_1.out
2018-03-09 14:00:04 +09:00
Masahiko Sawada
a0fe223f8b Forgot to add expected files of regression tests. 2018-03-09 11:00:42 +09:00
Masahiko Sawada
2f6196d654 Always qualify relation names.
Due to change at PostgreSQL 10.3, 9.6.8, 9.5.12, 9.4.17 and 9.3.22,
relation names passed by PostgreSQL function such as
pg_get_indexdef_string() are schema-qualified, which could be cause
of a parse error.
2018-03-09 10:53:43 +09:00
Alexey Bashtanov
731c4ee405 Avoid excessive locking when table already being repacked by another instance 2018-01-17 11:24:23 +00:00
Masahiko Sawada
bf61feefc4 Fix Japanese doc. 2017-10-17 12:16:44 +09:00
Masahiko Sawada
4fa4f8945e Fix change logs of version 1.4.1 and 1.4.2. 2017-10-17 12:11:28 +09:00
Masahiko Sawada
fdad0b87a2 Fix Japanese doc. 2017-10-17 18:03:07 +09:00
Daniele Varrazzo
7166a0ee8c Preparing release 1.4.2 2017-10-13 09:16:37 +01:00
Masahiko Sawada
4b86bb1c41 Merge pull request #150 from MasahikoSawada/fix_regress_test
Change to use only the characters that are printable ASCII.
2017-10-04 11:05:53 +09:00
Masahiko Sawada
f690ada80f Change to use only the characters that are printable ASCII.
The regression test could fail on some environments such as where
the encoding is SQL_ASCII.

Fixed issue #130.
2017-10-03 11:51:07 -07:00
Josh Kupershmidt
f83cb2a6e0 Merge pull request #149 from craigds/patch-1
Clarify note about GiST indexes
2017-10-03 08:48:08 -04:00
Craig de Stigter
f789bc965d Clarify note about GiST indexes
As per http://lists.pgfoundry.org/pipermail/reorg-general/2015-May/000306.html
2017-09-29 14:03:02 +13:00
Masahiko Sawada
66f5da58c9 Update Japanese doc for the recent changes. 2017-09-25 11:19:22 -07:00
Daniele Varrazzo
1cb3a52ccb Changelog updated with last developments 2017-09-25 03:17:00 +01:00
Daniele Varrazzo
d7b4e75c10 PG 10 expected test result fixed with changes added in 1.4.1 2017-09-25 02:53:11 +01:00
Daniele Varrazzo
7413a65985 Merge remote-tracking branch 'origin/master' into pg10 2017-09-25 02:45:49 +01:00
Daniele Varrazzo
9e4dd00415 Dropped compiler warning
Probably only raised compiling on 32 bits platforms.
2017-09-25 02:37:29 +01:00
Daniele Varrazzo
f996fd8fb3 Allow building with PostgreSQL 10rc1
This is what we get:

    $ pg_config --version
    PostgreSQL 10rc1
2017-09-25 02:33:13 +01:00
Masahiko Sawada
b2d470a122 Merge pull request #143 from MasahikoSawada/fix_lock_exclusive
Reset the transcation state before exiting from lock_exclusive.
2017-08-24 09:20:08 +09:00
Masahiko Sawada
900bb8369b Reset the transcation state before exiting from lock_exclusive.
Previously we exited from lock_exclusive() while opening the
transaction that started at beggning if --no-kill-backend option
is specified. This caused that DROP INDEX CONCURRENTLY fails
because it cannot be executed within a user transaction block.

Fixed issue #129.
2017-08-18 15:25:04 +09:00
Justin Pryzby
1b651bd3d9 Avoid return from lock_exclusive() while in transaction ..
..causing "ERROR: DROP INDEX CONCURRENTLY cannot run inside a transaction block"
github#129
2017-08-18 15:21:09 +09:00
Masahiko Sawada
20f5bf4878 Update pg_repack_jp.rst for release 1.4.1. 2017-08-13 00:32:13 +09:00
Daniele Varrazzo
ea27a94578 Typo fixed (after releasing, of course...) 2017-08-12 13:15:14 +01:00
Daniele Varrazzo
b2be4741c9 Preparing release 1.4.1 2017-08-12 12:56:43 +01:00
Masahiko Sawada
766937ab4c Merge pull request #140 from MasahikoSawada/fix_order
Fix reorganize table without sorting.
2017-08-12 13:25:16 +09:00
Masahiko Sawada
34e71adbbd Fix a typo in pg_repack.c file. 2017-08-05 20:16:31 +09:00
Masahiko Sawada
f8ba09fd31 Get rid of unnecessary lines in expected file. 2017-08-05 02:49:56 +09:00