From f3535de79039407511f815eecdba920b9b56408a Mon Sep 17 00:00:00 2001 From: Kyotaro Horiguchi Date: Fri, 8 Feb 2019 12:28:02 +0900 Subject: [PATCH 2/2] Let ALTER TABLE accept new storage class "compress" This patch adds new choice of storage class in ALTER TABLE, "compress", which means compress in-line, but don't make it out-of-line. Likewise plain, toast relations once created won't be removed even when no attribute that needs toast relation remains. --- src/backend/commands/tablecmds.c | 2 ++ 1 file changed, 2 insertions(+) diff --git a/src/backend/commands/tablecmds.c b/src/backend/commands/tablecmds.c index a7b37d6e2b..bd49a6f259 100644 --- a/src/backend/commands/tablecmds.c +++ b/src/backend/commands/tablecmds.c @@ -6613,6 +6613,8 @@ ATExecSetStorage(Relation rel, const char *colName, Node *newValue, LOCKMODE loc newstorage = 'x'; else if (pg_strcasecmp(storagemode, "main") == 0) newstorage = 'm'; + else if (pg_strcasecmp(storagemode, "compress") == 0) + newstorage = 'c'; else { ereport(ERROR, -- 2.16.3