Re: [ADMIN] How to get the DML Commands exceuted from functions - Mailing list pgsql-general

From Karthikeyan Sundaram
Subject Re: [ADMIN] How to get the DML Commands exceuted from functions
Date
Msg-id BAY131-W8A0ADCCEA47B2DB628B78B06A0@phx.gbl
Whole thread Raw
List pgsql-general
CREATE OR REPLACE FUNCTION xyz() returns int4 as
$body$
DECLARE
....
BEGIN
      IF (TG_OP = 'DELETE') THEN
         n_id = OLD.campaign_id;
         EXECUTE 'DELETE FROM cn_mapping WHERE campaign_id = '||quote_literal(n_id);
         RETURN 0;
      END IF;
END;
$body$
 LANGUAGE 'plpgsql' VOLATILE;


 

Date: Fri, 23 Mar 2007 10:44:49 +0530
From: anoo.postgresql@gmail.com
To: pgsql-admin@postgresql.org; pgsql-general@postgresql.org
Subject: [ADMIN] How to get the DML Commands exceuted from functions

Hi All,
 
There are a few plpgsql functions in our application, When the functions are called, I would like to see the commands executed from the functions ( the selects, inserts, updates and Deletes written in the function body) 
 
I am from SQL server world and there exists a tool SQL Profiler for the same purpose. I am looking for something like that
 
 
Thanks in advance
 
Anoo.S


Take a break and play crossword puzzles - FREE! Play Now!

pgsql-general by date:

Previous
From: "Anoo Pillai"
Date:
Subject: How to get the DML Commands exceuted from functions
Next
From: Henrik Zagerholm
Date:
Subject: Query not using index pgsql 8.2.3