From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | Kevin Burke <kev(at)inburke(dot)com> |
Cc: | Michael Nolan <htfoot(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Debugging a function - what's the best way to do this quickly? |
Date: | 2017-12-19 19:55:23 |
Message-ID: | CANu8FixGHrvNUxxDsVd5U06JciAdtOo+aepzBj2=E+QfgTzLiQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Dec 19, 2017 at 2:47 PM, Kevin Burke <kev(at)inburke(dot)com> wrote:
> 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 <(925)%20271-7005> | kev.inburke.com
>
> On Tue, Dec 19, 2017 at 11:43 AM, Michael Nolan <htfoot(at)gmail(dot)com> wrote:
>
>>
>>
>> On Tue, Dec 19, 2017 at 1:24 PM, Kevin Burke <kev(at)inburke(dot)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.
>>>
>>> --
>>> Kevin Burke
>>> 925.271.7005 <(925)%20271-7005> | kev.inburke.com
>>>
>>
>> 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
>>
>
>
*>Can you describe what you mean by log statements? *
*What he probably means is make use of the RAISE NOTIFY statement.*
*https://www.postgresql.org/docs/9.6/static/plpgsql-errors-and-messages.html#PLPGSQL-STATEMENTS-RAISE
<https://www.postgresql.org/docs/9.6/static/plpgsql-errors-and-messages.html#PLPGSQL-STATEMENTS-RAISE>*
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
From | Date | Subject | |
---|---|---|---|
Next Message | Kellner Thiemo | 2017-12-20 07:02:40 | RE: PostgreSQL suitable? |
Previous Message | Kevin Burke | 2017-12-19 19:47:55 | Re: Debugging a function - what's the best way to do this quickly? |