Re: How to get the DML Commands exceuted from functions

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 +0530From: anoo(dot)postgresql(at)gmail(dot)comTo: pgsql-admin(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)orgSubject: [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!
http://games.msn.com/en/flexicon/default.htm?icid=flexicon_ wlmemailtaglinemarch07