pgsql: Fix ALTER COLUMN TYPE to preserve the tablespace and reloptions - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Fix ALTER COLUMN TYPE to preserve the tablespace and reloptions
Date
Msg-id 20071013155608.4CCB3753E8A@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Fix ALTER COLUMN TYPE to preserve the tablespace and reloptions of indexes
it affects.  The original coding neglected tablespace entirely (causing
the indexes to move to the database's default tablespace) and for an index
belonging to a UNIQUE or PRIMARY KEY constraint, it would actually try to
assign the parent table's reloptions to the index :-(.  Per bug #3672 and
subsequent investigation.

8.0 and 8.1 did not have reloptions, but the tablespace bug is present.

Tags:
----
REL8_0_STABLE

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        ruleutils.c (r1.188.4.5 -> r1.188.4.6)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/ruleutils.c?r1=1.188.4.5&r2=1.188.4.6)
    pgsql/src/backend/utils/cache:
        lsyscache.c (r1.119 -> r1.119.4.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/cache/lsyscache.c?r1=1.119&r2=1.119.4.1)
    pgsql/src/include/utils:
        lsyscache.h (r1.93 -> r1.93.4.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/lsyscache.h?r1=1.93&r2=1.93.4.1)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix ALTER COLUMN TYPE to preserve the tablespace and reloptions
Next
From: fxjr@pgfoundry.org (User Fxjr)
Date:
Subject: npgsql - Npgsql2: Updated nant build file and Monodevelop project files