| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> | 
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org | 
| Subject: | pgsql: Implement ALTER TABLE .. SET LOGGED / UNLOGGED | 
| Date: | 2014-08-22 18:30:15 | 
| Message-ID: | E1XKtbL-0001B9-6k@gemulon.postgresql.org | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-committers | 
Implement ALTER TABLE .. SET LOGGED / UNLOGGED
This enables changing permanent (logged) tables to unlogged and
vice-versa.
(Docs for ALTER TABLE / SET TABLESPACE got shuffled in an order that
hopefully makes more sense than the original.)
Author: Fabrízio de Royes Mello
Reviewed by: Christoph Berg, Andres Freund, Thom Brown
Some tweaking by Álvaro Herrera
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/f41872d0c1239d36ab03393c39ec0b70e9ee2a3c
Modified Files
--------------
doc/src/sgml/ref/alter_table.sgml         |   64 ++++----
src/backend/commands/cluster.c            |   46 +++---
src/backend/commands/matview.c            |    9 +-
src/backend/commands/tablecmds.c          |  239 ++++++++++++++++++++++++++++-
src/backend/parser/gram.y                 |   17 +-
src/bin/psql/tab-complete.c               |    4 +-
src/include/commands/cluster.h            |    2 +-
src/include/nodes/parsenodes.h            |    2 +
src/include/parser/kwlist.h               |    1 +
src/test/regress/expected/alter_table.out |   91 +++++++++++
src/test/regress/sql/alter_table.sql      |   52 +++++++
11 files changed, 472 insertions(+), 55 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2014-08-23 04:39:29 | pgsql: doc: Improve pg_restore help output | 
| Previous Message | Tom Lane | 2014-08-22 17:18:22 | pgsql: Fix corner-case behaviors in JSON/JSONB field extraction operato |