df12c37edfAdd in a call to: ALTER TABLE [table_name] ENABLE ALWAYS TRIGGER z_reorg_trigger
Josh Kupershmidt
2012-10-14 10:50:05 -07:00
370e572cfcGet rid of support for PG versions 8.2 and earlier. These have been unsupported for some time, and the #defines do clutter up the codebase.
Josh Kupershmidt
2012-09-19 17:04:42 -07:00
2226f2011dDocumentation fixes for the English and Japanese HTML doc pages
Daniele Varrazzo
2012-09-22 19:58:49 +01:00
59db5d4630Make ordering of 'Options' printed by pg_reorg --help alphabetical.
Josh Kupershmidt
2012-09-19 16:49:03 -07:00
bc20ace32bUse quote_identifier() to properly escape column names in UPDATE statement, per report from Dimitrije Radojevic.
Josh Kupershmidt
2012-09-18 20:13:21 -07:00
612495ecd6Print a status message while waiting on old transactions to finish, including a backend PID we are waiting on, so that the user knows pg_reorg is hung and can do something about it.
Josh Kupershmidt
2012-09-14 22:07:58 -07:00
960930b645Fixed database corruption when target tables have dropped columns, and there are views or functions depending on columns after dropped ones. The issue was reported by depesz, and original patch by Denish Patel.
Takahiro Itagaki
2011-04-29 05:06:48 +00:00
830ef422adwork around for 9.1.
Takahiro Itagaki
2011-03-03 01:21:40 +00:00
232c9bb6c9Use one of not-null unique keys to identify rows when the target table doesn't have a primary key. Some of users want to use not-null unique keys rather than primary keys because postgres doesn't support REINDEX PRIMARY KEY CONCURRENTLY.
Takahiro Itagaki
2011-01-06 09:35:15 +00:00
d8d39cc948Fix memory leak and wrong usage of StringInfo in pgut_connect().
Masahiko Sakamoto
2010-10-21 07:36:13 +00:00
7865250a19Fixed problem with interactive authentication handling.
Masahiko Sakamoto
2010-09-29 07:29:29 +00:00
8ab15f2e72Add documentation to build the module with pgxs.
Takahiro Itagaki
2010-07-09 04:54:27 +00:00
d490a1b458Fix -w and -W options. They were inverted.
Takahiro Itagaki
2010-06-18 01:12:28 +00:00
67a5d7b786Fix a bug that pg_reorg cannot parse index definitions with reserved named columns, i.e, it failed to parse quoted column names. (bug #1010828)
Takahiro Itagaki
2010-06-14 05:11:26 +00:00
78b0a0e374Fix two bugs. #1010789 : pg_reorg 1.1.0 and "unexpected toast relations" #1010790 : reorg.get_index_keys() does not handle composite indexes
Takahiro Itagaki
2010-04-21 09:25:20 +00:00
f3873ff55bpg_reorg version 1.1.0. - Add wait-timeout option and use SET statement_timeout instead of NOWAIT. This can avoid infinite NOWAIT loops to reorganize heavily accessed tables. - Support native build with MSVC on Windows.
Takahiro Itagaki
2010-03-25 07:13:16 +00:00
5ee824097eAdd COPYRIGHT file to clear pg_reorg is licensed under simplefied BSD license.
Takahiro Itagaki
2009-07-02 09:53:13 +00:00
6155932b60Fix data corruption bug reported by robjderr (#1010664). pg_reorg broke catalog definition if the target table had any dropped columns. Now pg_reorg removes dropped columns and renumbers valid columns. You can use pg_reorg to shrink column definitions if you have many dropped columns. (without pg_reorg, dropped columns are filled with zero forever)
Takahiro Itagaki
2009-07-02 09:50:58 +00:00
5fe3f037beversion 1.0.5. - Disable autovacuum for working tables and update logs. - Do ANALYZE automatically after reorg unless -Z, --no-analyze option is specified.
Takahiro Itagaki
2009-05-25 07:06:38 +00:00
9a8f2e9c33Fix ownership bug. New toast table, toast index, and toast type should not have been owned by the executor of pg_reorg, but by the original owner.
Takahiro Itagaki
2009-05-14 08:19:25 +00:00
0c659ed31fFix compile errors on Linux.
Takahiro Itagaki
2009-04-23 06:37:29 +00:00
e1011e11feModify LOCK to LOCK-NOWAIT-and-loop at swap tables to avoid holding exclusive locks long time. Suggested by Kenny Gorman.
Takahiro Itagaki
2009-04-16 06:01:01 +00:00
942180c2d8workaround with 8.2.
Takahiro Itagaki
2009-01-27 01:35:53 +00:00
aab19c7db0Fixed a bug reorganizing tables without toast tables.
Takahiro Itagaki
2009-01-23 02:33:11 +00:00
24a03c01a5workaround for toast tables. The bug is reported by Kenny Gorman.
Takahiro Itagaki
2009-01-21 08:09:22 +00:00
29469f40f9Move drop function calls to another transaction which doesn't have execlusive locks.
Takahiro Itagaki
2009-01-19 04:28:21 +00:00