From: | Dane Foster <studdugie(at)gmail(dot)com> |
---|---|
To: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PL/pgSQL debugger |
Date: | 2016-01-29 21:26:51 |
Message-ID: | CA+WxinKDqmFFmi4Gtq9fFmvH8fyjv+qBdAu160BkqW+XT9=15w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jan 29, 2016 at 4:22 PM, Melvin Davidson <melvin6925(at)gmail(dot)com>
wrote:
> You did not indicate which O/S you are using, but here are the detailed
> instructions for Windows.
>
>
> http://blog.databasepatterns.com/2014/01/installing-debugger-for-pgadmin-on.html
>
> Note that the most important part is to load the .dll in postgresql.conf.
>
> shared_preload_libraries = '$libdir/plugin_debugger.dll'
>
> This should also work for Linux, providing you have the .dll
>
> On Fri, Jan 29, 2016 at 4:02 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
>
>> Hi
>>
>> 2016-01-29 21:52 GMT+01:00 Dane Foster <studdugie(at)gmail(dot)com>:
>>
>>> Hello,
>>>
>>> I googled "plpgsql debugger" and eventually ended up at
>>> http://pgfoundry.org/projects/edb-debugger/, where the latest release
>>> is almost 8 years old. I am aware that this is not an EDB forum but given
>>> that I sent them an e-mail at 9AM EST and I haven't received a response yet
>>> I figured it can't hurt to try my question here. Is anyone using it on
>>> recent (e.g., 9.5) versions of PostgreSQL. If not, is there any consensus
>>> on what one should be using to debug PL/pgSQL functions?
>>>
>>
>> plpgsql debugger should be included directly in pgAdminIII
>>
>> The necessary extension can 8 years old - it implements communication
>> between client and server side code and this is long time without change
>>
>> http://www.pgadmin.org/docs/1.8/debugger.html
>>
>> Regards
>>
>> Pavel
>>
>>
>>> Thanks,
>>>
>>> Dane
>>>
>>
>>
>
>
> --
> *Melvin Davidson*
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
>
My workstation and laptop are Ubuntu Linux 15.10.
From | Date | Subject | |
---|---|---|---|
Next Message | Augori | 2016-01-29 22:59:42 | Transaction check error installing PostGIS |
Previous Message | Melvin Davidson | 2016-01-29 21:22:56 | Re: PL/pgSQL debugger |