Re: [pgadmin-support] PostgreSQL 9.6.1: Debug window does not loadfunction sql

Поиск
Список
Период
Сортировка
От Shakti Singh
Тема Re: [pgadmin-support] PostgreSQL 9.6.1: Debug window does not loadfunction sql
Дата
Msg-id CAH19Pkk6QJP5j6w4UFuZzvUHg5YBdowpjm08CxcjneEH7cNecQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [pgadmin-support] PostgreSQL 9.6.1: Debug window does not loadfunction sql  (Murtuza Zabuawala <murtuza.zabuawala@enterprisedb.com>)
Ответы Re: [pgadmin-support] PostgreSQL 9.6.1: Debug window does not loadfunction sql
Список pgadmin-support
Дерево обсуждения
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)]

Inline image 2

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.0123@gmail.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
 


В списке pgadmin-support по дате отправления: