From: | Siddharth Saha <siddharthsaha(at)drishti-soft(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Cc: | Nishant Bangarwa <nishantbangarwa(at)drishti-soft(dot)com> |
Subject: | [NOVIE] raise notice not working for nested function calls |
Date: | 2010-07-15 06:00:54 |
Message-ID: | AANLkTim0yg84eqkg9MKh3elg2Jcv6iHZ0nNW_JAdv6NS@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I call a function which in turn is calling another function. In the both the
functions there is a RAISE NOTICE command. But the RAISE NOTICE is
working(printing to the console) only for the first function and not for the
function called from within the main function.
Furthermore, I tried to insert the message in the RAISE NOTICE's message in
the second function into a table. And then I call the main function. Then
also it does not insert into the table.
Essentially, I want to print the query which is formed in the second
function and it depends on the parameters which the main function is passing
to it. Returning the query formed to the main function and printing it is
not a feasible solution in my case.
Please suggest how to accomplish this.
Your help is appreciated.
-Siddharth
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Holleran | 2010-07-15 09:03:58 | Re: function runs slow |
Previous Message | A. Kretschmer | 2010-07-15 05:47:59 | Re: function runs slow |