reorg - pg_reorg: Fix data corruption bug reported by robjderr

From: itagaki(at)pgfoundry(dot)org (User Itagaki)
To: pgsql-committers(at)postgresql(dot)org
Subject: reorg - pg_reorg: Fix data corruption bug reported by robjderr
Date: 2009-07-02 09:50:59
Message-ID: 20090702095059.0741F10721F6@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
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)

Modified Files:
--------------
pg_reorg/bin:
pg_reorg.c (r1.8 -> r1.9)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/bin/pg_reorg.c?r1=1.8&r2=1.9)
pg_reorg/bin/expected:
reorg.out (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/bin/expected/reorg.out?r1=1.3&r2=1.4)
pg_reorg/bin/pgut:
pgut.c (r1.4 -> r1.5)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/bin/pgut/pgut.c?r1=1.4&r2=1.5)
pgut.h (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/bin/pgut/pgut.h?r1=1.3&r2=1.4)
pg_reorg/bin/sql:
reorg.sql (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/bin/sql/reorg.sql?r1=1.3&r2=1.4)
pg_reorg/lib:
Makefile (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/lib/Makefile?r1=1.3&r2=1.4)
pg_reorg.sql.in (r1.5 -> r1.6)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/lib/pg_reorg.sql.in?r1=1.5&r2=1.6)
reorg.c (r1.8 -> r1.9)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/lib/reorg.c?r1=1.8&r2=1.9)
pg_reorg/lib/pgut:
pgut-be.c (r1.1 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/lib/pgut/pgut-be.c?r1=1.1&r2=1.2)
pgut-be.h (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/reorg/pg_reorg/lib/pgut/pgut-be.h?r1=1.2&r2=1.3)

Browse pgsql-committers by date

  From Date Subject
Next Message User Itagaki 2009-07-02 09:53:13 reorg - pg_reorg: Add COPYRIGHT file to clear pg_reorg is licensed under
Previous Message Peter Eisentraut 2009-07-02 07:03:18 pgsql: Regression test for XML mapping functionality I wrote this one