Re: Problem with DEBUG messages

Поиск
Список
Период
Сортировка
От Michael Shapiro
Тема Re: Problem with DEBUG messages
Дата
Msg-id CAGCvxebmi2gu2d7dvgxRfx3SmiV8WNc+U0943bSPddjURsjfFg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problem with DEBUG messages  (Dave Page <dpage@pgadmin.org>)
Ответы Re: Problem with DEBUG messages  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-support
Yes and no.<br /><br />If I run the script that creates the function, does the set client_min_messages, then runs the
function,<br/>I get the DEBUG.<br /><br />But then if I just runt he function (in a new query window). I do not get the
DEBUGmessages.<br /><br />However, if I add<br /><br />    SET client_min_messages to 'DEBUG';<br /><br />in the query
windowbefore I run the function, I see the messages.<br /><br />So<br /><br />  select test_debug(1)<br /><br />doesn't
work,but<br /><br /><br />   SET client_min_messages to 'DEBUG';<br />   select test_debug(1)<br /><br />does work,<br
/><br/><div class="gmail_quote">On Tue, Apr 9, 2013 at 10:53 AM, Dave Page <span dir="ltr"><<a
href="mailto:dpage@pgadmin.org"target="_blank">dpage@pgadmin.org</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">On Tue, Apr 9,
2013at 4:47 PM, Michael Shapiro <<a href="mailto:mshapiro51@gmail.com">mshapiro51@gmail.com</a>> wrote:<br />
>I have a very similar function and client_min_message set exactly the same,<br /> > When I run the procedure in
thequery tool, I do not see any DEBUG message.<br /> > If I run it in PSQL console, the DEBUG message appear.<br />
><br/> > There must be something in PgAdmin that is doing this ...<br /> ><br /><br /></div>Does my test
scriptwork for you?<br /><div class="HOEnZb"><div class="h5"><br /> --<br /> Dave Page<br /> Blog: <a
href="http://pgsnake.blogspot.com"target="_blank">http://pgsnake.blogspot.com</a><br /> Twitter: @pgsnake<br /><br />
EnterpriseDBUK: <a href="http://www.enterprisedb.com" target="_blank">http://www.enterprisedb.com</a><br /> The
EnterprisePostgreSQL Company<br /></div></div></blockquote></div><br /> 

В списке pgadmin-support по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Problem with DEBUG messages
Следующее
От: Veenu Kumar Mani
Дата:
Сообщение: pgadmin II