Re: PostgreSQL 9.6.1: Debug window does not load function sql

Hi,

There is an issue with PG 9.6 in Windows and pldebugger.
Can you please test with PG 9.5 ? It should work other then v9.6 on windows.

Thanks,
Neel Patel

On Wed, Dec 21, 2016 at 7:15 PM, Shakti Singh <shakti(dot)0123(at)gmail(dot)com> wrote:

> Hi,
>
> Is there anyway or workaround this issue?
>
> Thanks,
>
> Shakti Singh
>
>
>
> On Thu, Dec 15, 2016 at 8:31 AM, Shakti Singh <shakti(dot)0123(at)gmail(dot)com>
> wrote:
>
>> Hello,
>>
>> The sample function create script is:
>>
>>
>>
>> CREATE OR REPLACE FUNCTION "schema1"."utils.Get_datetime"
>> (
>> in in_datetime_string varchar(4000),
>> out out_datetime timestamp
>>
>> ) AS $$
>> DECLARE
>> ok boolean;
>> BEGIN
>> ok := true;
>> IF in_datetime_string is not null then
>> BEGIN
>> out_datetime := to_timestamp(in_datetime_string, 'MM/DD/YYYY
>> HH24:MI:SS');
>> ok := true;
>> EXCEPTION
>> when others then
>> ok := false;
>> END;
>> ELSE
>> ok := true;
>> END IF;
>> END; $$ language plpgsql;
>>
>> where schema1 is the schema
>> "utils.Get_datetime" function name
>>
>> The query "select * from "schema1"."utils.Get_datetime"('02/02/2016
>> 02:22:35');" returns the correct result.
>>
>> *OS Version: *Windows 2012 R2
>> *pgAdmin 4 Version: *Version1.1
>> *Python Version: *2.7.11 (v2.7.11:6d1b6a68f775, Dec 5
>> 2015, 20:40:30) [MSC v.1500 64 bit (AMD64)]
>>
>> [image: Inline image 2]
>>
>> [image: Inline image 3]
>>
>>
>> Thanks,
>>
>>
>> Shakti Singh
>>
>>
>> On Thu, Dec 15, 2016 at 12:26 AM, Murtuza Zabuawala <
>> murtuza(dot)zabuawala(at)enterprisedb(dot)com> wrote:
>>
>>> Hi,
>>>
>>> Could you provide steps to re-produce the issue with your sample
>>> code/screenshot?
>>>
>>> And also,
>>> OS version- ?
>>> Python version - ?
>>> pgAdmin4 version - ?
>>>
>>>
>>> --
>>> Regards,
>>> Murtuza Zabuawala
>>> EnterpriseDB: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>> On Wed, Dec 14, 2016 at 7:14 PM, Shakti Singh <shakti(dot)0123(at)gmail(dot)com>
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> I am working on a POC to port Oracle database to PostGreSQL.
>>>> I am trying to debug a function in pgAdmin 4 after enabling debugger.
>>>>
>>>> The Debugger window that opens in pgAdmin 4 for a function does not
>>>> show any function code because of which I cannot put a break point.
>>>>
>>>> Any help is appreciated.
>>>>
>>>> Thanks
>>>>
>>>> Shakti Singh
>>>>
>>>>
>>>
>>>
>>
>