Horton
Menu

0001-add-type-info-logging.patch

text/x-patch

Download
Filename: 0001-add-type-info-logging.patch
Type: text/x-patch
Part: 0
Message: Re: Patch: Log parameter types in detailed query logging

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →
Format: unified
Series: patch 0001
File+−
src/backend/nodes/params.c 4 3 
diff --git a/src/backend/nodes/params.c b/src/backend/nodes/params.c
index 3acc7508e71..49df56f0135 100644
--- a/src/backend/nodes/params.c
+++ b/src/backend/nodes/params.c
@@ -21,11 +21,11 @@
 #include "nodes/params.h"
 #include "parser/parse_node.h"
 #include "storage/shmem.h"
+#include "utils/builtins.h"
 #include "utils/datum.h"
 #include "utils/lsyscache.h"
 #include "utils/memutils.h"
 
-
 static void paramlist_parser_setup(ParseState *pstate, void *arg);
 static Node *paramlist_param_ref(ParseState *pstate, ParamRef *pref);
 
@@ -367,9 +367,10 @@ BuildParamLogString(ParamListInfo params, char **knownTextValues, int maxlen)
 		ParamExternData *param = &params->params[paramno];
 
 		appendStringInfo(&buf,
-						 "%s$%d = ",
+						 "%s$%d = (%s)",
 						 paramno > 0 ? ", " : "",
-						 paramno + 1);
+						 paramno + 1,
+						 format_type_extended(param->ptype, -1, FORMAT_TYPE_ALLOW_INVALID));
 
 		if (param->isnull || !OidIsValid(param->ptype))
 			appendStringInfoString(&buf, "NULL");