farrokhi/pg_repack
1
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
486 Commits 1 Branch 0 Tags
Commit Graph

486 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
Masahiko Sakamoto
f2fed2415d Fixes for 9.2devel. reported by Josh. 
- Since 9.2, RenameRelationInternal() has changed its signature.
- In CREATE FUNCTION, LANGUAGE clause does not accept string.
 2012-05-01 06:11:49 +00:00
Takahiro Itagaki
815dd72774 Fix docs. 2011-08-07 04:24:39 +00:00
Takahiro Itagaki
aad43aa1ae version 1.1.7. Supports 9.2dev. 2011-08-07 04:20:23 +00:00
Takahiro Itagaki
960930b645 Fixed 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.

Improved documentation how to build binaries from source.

COPYRIGHT updated.
 2011-04-29 05:06:48 +00:00
Takahiro Itagaki
830ef422ad work around for 9.1. 2011-03-03 01:21:40 +00:00
Takahiro Itagaki
8ec3a085ad Added project configuration files for MSVC 2010 32/64bit. 2011-01-25 06:41:12 +00:00
Takahiro Itagaki
232c9bb6c9 Use 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.

- Support 9.1dev.
- Improve Makefile to use PGXS automatically.
 2011-01-06 09:35:15 +00:00
Masahiko Sakamoto
d8d39cc948 Fix memory leak and wrong usage of StringInfo in pgut_connect(). 2010-10-21 07:36:13 +00:00
Masahiko Sakamoto
7865250a19 Fixed problem with interactive authentication handling. 
Previous pgut.c didn't handle any user-input during interactive authentication.
 2010-09-29 07:29:29 +00:00
Takahiro Itagaki
8ab15f2e72 Add documentation to build the module with pgxs. 2010-07-09 04:54:27 +00:00
Takahiro Itagaki
d490a1b458 Fix -w and -W options. They were inverted. 2010-06-18 01:12:28 +00:00
Takahiro Itagaki
67a5d7b786 Fix a bug that pg_reorg cannot parse index definitions with reserved named columns, 
i.e, it failed to parse quoted column names. (bug #1010828)
 2010-06-14 05:11:26 +00:00
Takahiro Itagaki
79757ccb62 version 1.1.2. 2010-06-01 07:35:01 +00:00
Takahiro Itagaki
9bed2e6b2e Fix a bug in --username option. 2010-05-25 04:53:23 +00:00
Takahiro Itagaki
6e05a366fa Fix double-free bug with -a (--all) option. 2010-05-14 06:52:45 +00:00
Takahiro Itagaki
1cd2b095ac pg_reorg 1.1.1. 2010-04-22 01:29:08 +00:00
Takahiro Itagaki
78b0a0e374 Fix two bugs. 
#1010789 : pg_reorg 1.1.0 and "unexpected toast relations"
#1010790 : reorg.get_index_keys() does not handle composite indexes
 2010-04-21 09:25:20 +00:00
Takahiro Itagaki
f3873ff55b pg_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.
 2010-03-25 07:13:16 +00:00
Takahiro Itagaki
8392b9462a version 1.0.8. 2010-02-15 01:38:06 +00:00
Takahiro Itagaki
a7a42b7bbf Fix crashes when cluster indexes have storage options (fillfactor, etc). 2010-02-05 03:24:22 +00:00
Takahiro Itagaki
7084ec6de9 version 1.0.7. 2010-01-28 06:02:28 +00:00
Takahiro Itagaki
038c07523a Support reorganizing tables with non-default operator class. 2009-12-28 08:25:00 +00:00
Takahiro Itagaki
27e6839132 Release 1.0.6. Workaround for 8.2 and 8.3. 2009-07-03 05:52:31 +00:00
Takahiro Itagaki
2f2fa142b8 Add pgut-spi files. 2009-07-02 09:55:57 +00:00
Takahiro Itagaki
5ee824097e Add COPYRIGHT file to clear pg_reorg is licensed under simplefied BSD license. 2009-07-02 09:53:13 +00:00
Takahiro Itagaki
6155932b60 Fix 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)
 2009-07-02 09:50:58 +00:00
Takahiro Itagaki
5fe3f037be version 1.0.5. 
- Disable autovacuum for working tables and update logs.
- Do ANALYZE automatically after reorg unless -Z, --no-analyze option
  is specified.
 2009-05-25 07:06:38 +00:00
Takahiro Itagaki
9a8f2e9c33 Fix 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.
 2009-05-14 08:19:25 +00:00
Takahiro Itagaki
0c659ed31f Fix compile errors on Linux. 2009-04-23 06:37:29 +00:00
Takahiro Itagaki
574b6dc296 Support PGXS. 2009-04-22 07:26:12 +00:00
Takahiro Itagaki
e1011e11fe Modify LOCK to LOCK-NOWAIT-and-loop at swap tables to avoid holding exclusive locks long time. Suggested by Kenny Gorman. 2009-04-16 06:01:01 +00:00
Takahiro Itagaki
942180c2d8 workaround with 8.2. 2009-01-27 01:35:53 +00:00
Takahiro Itagaki
aab19c7db0 Fixed a bug reorganizing tables without toast tables. 2009-01-23 02:33:11 +00:00
Takahiro Itagaki
24a03c01a5 workaround for toast tables. The bug is reported by Kenny Gorman. 2009-01-21 08:09:22 +00:00
Takahiro Itagaki
29469f40f9 Move drop function calls to another transaction which doesn't have execlusive locks. 2009-01-19 04:28:21 +00:00
Takahiro Itagaki
8af8be23ac Initial revision 2008-12-08 04:32:10 +00:00