Simple patch to report in log the schema name of the statement

From: Ferruccio Zamuner <nonsolosoft(at)diff(dot)org>
To: pgsql-patches(at)postgresql(dot)org
Subject: Simple patch to report in log the schema name of the statement
Date: 2007-07-31 23:46:32
Message-ID: 46AFC9D8.4040704@diff.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

./src/backend/utils/error/elog.c
*** ./src/backend/utils/error/elog.c.orig Wed Aug 1 00:48:55 2007
--- ./src/backend/utils/error/elog.c Wed Aug 1 00:53:16 2007
***************
*** 68,74 ****
--- 68,76 ----
#include "storage/ipc.h"
#include "tcop/tcopprot.h"
#include "utils/memutils.h"
+ #include "utils/guc.h"
#include "utils/ps_status.h"
+ #include "catalog/namespace.h"


/* Global variables */
***************
*** 1541,1546 ****
--- 1543,1552 ----
case '%':
appendStringInfoChar(buf, '%');
break;
+ case 'S':
+ if (namespace_search_path != NULL)
+ appendStringInfo(buf, "%s ",
namespace_search_path);
+ break;
default:
/* format error - ignore it */
break;
./src/backend/utils/misc/postgresql.conf.sample
*** ./src/backend/utils/misc/postgresql.conf.sample.orig Sat Jan
20 22:42:06 2007
--- ./src/backend/utils/misc/postgresql.conf.sample Wed Aug 1
01:38:16 2007
***************
*** 328,333 ****
--- 330,336 ----
# %c = session id
# %l = session line number
# %s = session start timestamp
+ # %S = schema
# %x = transaction id
# %q = stop here in non-session
# processes

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2007-08-01 01:48:19 Re: Export user visible function to make use of convert_to_scalar
Previous Message Gregory Stark 2007-07-31 23:08:12 Re: Export user visible function to make use of convert_to_scalar