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

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