pgsql: Replace ALTER TABLE ...

From: rhaas(at)postgresql(dot)org (Robert Haas)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Replace ALTER TABLE ...
Date: 2010-01-22 16:40:19
Message-ID: 20100122164019.B6D167541B9@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Log Message:
-----------
Replace ALTER TABLE ... SET STATISTICS DISTINCT with a more general mechanism.

Attributes can now have options, just as relations and tablespaces do, and
the reloptions code is used to parse, validate, and store them. For
simplicity and because these options are not performance critical, we store
them in a separate cache rather than the main relcache.

Thanks to Alex Hunsaker for the review.

Modified Files:
--------------
pgsql/doc/src/sgml:
catalogs.sgml (r2.218 -> r2.219)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml?r1=2.218&r2=2.219)
pgsql/doc/src/sgml/ref:
alter_table.sgml (r1.109 -> r1.110)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/alter_table.sgml?r1=1.109&r2=1.110)
analyze.sgml (r1.27 -> r1.28)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/analyze.sgml?r1=1.27&r2=1.28)
pgsql/src/backend/access/common:
reloptions.c (r1.31 -> r1.32)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/common/reloptions.c?r1=1.31&r2=1.32)
tupdesc.c (r1.131 -> r1.132)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/common/tupdesc.c?r1=1.131&r2=1.132)
pgsql/src/backend/bootstrap:
bootstrap.c (r1.257 -> r1.258)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/bootstrap/bootstrap.c?r1=1.257&r2=1.258)
pgsql/src/backend/catalog:
genbki.pl (r1.6 -> r1.7)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/genbki.pl?r1=1.6&r2=1.7)
heap.c (r1.366 -> r1.367)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/heap.c?r1=1.366&r2=1.367)
index.c (r1.330 -> r1.331)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/index.c?r1=1.330&r2=1.331)
pgsql/src/backend/commands:
analyze.c (r1.147 -> r1.148)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/analyze.c?r1=1.147&r2=1.148)
tablecmds.c (r1.317 -> r1.318)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c?r1=1.317&r2=1.318)
pgsql/src/backend/parser:
gram.y (r2.703 -> r2.704)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y?r1=2.703&r2=2.704)
pgsql/src/backend/utils/cache:
Makefile (r1.24 -> r1.25)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/cache/Makefile?r1=1.24&r2=1.25)
pgsql/src/bin/pg_dump:
pg_dump.c (r1.567 -> r1.568)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c?r1=1.567&r2=1.568)
pg_dump.h (r1.160 -> r1.161)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.h?r1=1.160&r2=1.161)
pgsql/src/bin/psql:
tab-complete.c (r1.190 -> r1.191)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/tab-complete.c?r1=1.190&r2=1.191)
pgsql/src/include/access:
reloptions.h (r1.18 -> r1.19)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/access/reloptions.h?r1=1.18&r2=1.19)
pgsql/src/include/catalog:
pg_attribute.h (r1.157 -> r1.158)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_attribute.h?r1=1.157&r2=1.158)
pgsql/src/include/nodes:
parsenodes.h (r1.425 -> r1.426)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h?r1=1.425&r2=1.426)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Robert Haas 2010-01-22 16:42:31 pgsql: Fix several oversights in previous commit - attribute options
Previous Message Bruce Momjian 2010-01-22 15:49:29 pgsql: Document that the HTML documentation must be built before the PDF

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2010-01-22 16:50:34 Re: warn in plperl logs as... NOTICE??
Previous Message Tom Lane 2010-01-22 16:33:37 Re: Access to dynamic SQL in PL/pgSQL