Skip site navigation (1) Skip section navigation (2)

pgsql: Add an option to AlterTableCreateToastTable() to allow its caller

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add an option to AlterTableCreateToastTable() to allow its caller
Date: 2009-05-07 22:58:28
Message-ID: 20090507225828.59CB5754067@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Add an option to AlterTableCreateToastTable() to allow its caller to force
a toast table to be built, even if the sum-of-column-widths calculation
indicates one isn't needed.  This is needed by pg_migrator because if the
old table has a toast table, we have to migrate over the toast table since
it might contain some live data, even though subsequent column drops could
mean that no recently-added rows could require toasting.

Modified Files:
--------------
    pgsql/src/backend/catalog:
        toasting.c (r1.14 -> r1.15)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/toasting.c?r1=1.14&r2=1.15)
    pgsql/src/backend/commands:
        cluster.c (r1.183 -> r1.184)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/cluster.c?r1=1.183&r2=1.184)
        tablecmds.c (r1.281 -> r1.282)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c?r1=1.281&r2=1.282)
    pgsql/src/backend/executor:
        execMain.c (r1.323 -> r1.324)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execMain.c?r1=1.323&r2=1.324)
    pgsql/src/backend/tcop:
        utility.c (r1.306 -> r1.307)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/utility.c?r1=1.306&r2=1.307)
    pgsql/src/include/catalog:
        toasting.h (r1.6 -> r1.7)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/toasting.h?r1=1.6&r2=1.7)

pgsql-committers by date

Next:From: User BmomjianDate: 2009-05-08 02:44:41
Subject: pg-migrator - pg_migrator: Call AlterTableCreateToastTable() with new
Previous:From: Tom LaneDate: 2009-05-07 22:01:18
Subject: pgsql: Change pgbench to use the table names pgbench_accounts,

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group