Re: PL/pgSQL debugger

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.​

In response to

Browse pgsql-general by date

  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