>From 384131042a7a8d40a1f583d693ba46e19739e9a4 Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Thu, 25 Sep 2014 15:45:04 -0300 Subject: [PATCH 26/26] deparse: support COMMENT ON --- src/backend/tcop/deparse_utility.c | 35 ++++++++++++++++++++++++++++++++++- 1 file changed, 34 insertions(+), 1 deletion(-) diff --git a/src/backend/tcop/deparse_utility.c b/src/backend/tcop/deparse_utility.c index bb08a5d..8e3ab33 100644 --- a/src/backend/tcop/deparse_utility.c +++ b/src/backend/tcop/deparse_utility.c @@ -3781,6 +3781,38 @@ deparse_AlterOwnerStmt(Oid objectId, Node *parsetree) } static ObjTree * +deparse_CommentStmt(Oid objectId, Oid objectSubId, Node *parsetree) +{ + CommentStmt *node = (CommentStmt *) parsetree; + ObjTree *comment; + ObjectAddress addr; + char *fmt; + + if (node->comment) + { + fmt = psprintf("COMMENT ON %s %%{identity}s IS %%{comment}L", + stringify_objtype(node->objtype)); + comment = new_objtree_VA(fmt, 0); + append_string_object(comment, "comment", node->comment); + } + else + { + fmt = psprintf("COMMENT ON %s %%{identity}s IS NULL", + stringify_objtype(node->objtype)); + comment = new_objtree_VA(fmt, 0); + } + + addr.classId = get_objtype_catalog_oid(node->objtype); + addr.objectId = objectId; + addr.objectSubId = objectSubId; + + append_string_object(comment, "identity", + getObjectIdentity(&addr)); + + return comment; +} + +static ObjTree * deparse_CreateConversion(Oid objectId, Node *parsetree) { HeapTuple conTup; @@ -4641,7 +4673,8 @@ deparse_simple_command(StashedCommand *cmd) break; case T_CommentStmt: - command = NULL; + command = deparse_CommentStmt(objectId, cmd->d.simple.objectSubId, + parsetree); break; case T_GrantStmt: -- 1.9.1