Re: How to get the DML Commands exceuted from functions

[Karthikeyan Sundaram <skarthi98@xxxxxxxxxxx>]

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@xxxxxxxxx
To: pgsql-admin@xxxxxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx
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!