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

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.zabuawala@
> enterprisedb.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
>>>
>>>
>>
>>
>