Re: Debugging a function - what's the best way to do this quickly?

Поиск
Список
Период
Сортировка
От Kevin Burke
Тема Re: Debugging a function - what's the best way to do this quickly?
Дата
Msg-id CAGs5PJLp=f938AVz-fx_JZpH4Ru67X+szAtfVS6ioQsFSAeo7A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Debugging a function - what's the best way to do this quickly?  (Michael Nolan <htfoot@gmail.com>)
Ответы Re: Debugging a function - what's the best way to do this quickly?  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
Дерево обсуждения
Can you describe what you mean by log statements? I have log_statement enabled and I can see the queries; the problem is the output is not logged and not what I expect. I need to modify the function so it shows the output of an intermediate CTE when I run it with specific inputs, and that's currently a little cumbersome.


--
Kevin Burke
925.271.7005 | kev.inburke.com

On Tue, Dec 19, 2017 at 11:43 AM, Michael Nolan <htfoot@gmail.com> wrote:


On Tue, Dec 19, 2017 at 1:24 PM, Kevin Burke <kev@inburke.com> wrote:
I'm writing a function that looks a little like this:


This seems pretty cumbersome. Is there an easier way I am missing? Specifically it would be neat if it was easier to visualize the intermediate steps in the query production. If there are professional tools that help with this I would appreciate pointers to those as well.

Assuming it's not a function in production yet, put some log statements in it, then check the logs.  If it's already in production, you'll probably have to create a separate version of the function for testing.
--
Mike Nolan

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

Предыдущее
От: Michael Nolan
Дата:
Сообщение: Re: Debugging a function - what's the best way to do this quickly?
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: Debugging a function - what's the best way to do this quickly?