Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group