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: [EMAIL PROTECTED]:
pgsql-admin@postgresql.org; [EMAIL PROTECTED]: [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
