Thread: [pgadmin-support] 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)]
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,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.ThanksShakti Singh
Hi,
Is there anyway or workaround this issue?
Thanks,
Shakti Singh
On Thu, Dec 15, 2016 at 8:31 AM, Shakti Singh <shakti.0123@gmail.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 nameThe query "select * from "schema1"."utils.Get_datetime"('02/02/2016 02:22:35');" returns the correct result. OS Version: Windows 2012 R2pgAdmin 4 Version: Version1.1Python Version: 2.7.11 (v2.7.11:6d1b6a68f775, Dec 5 2015, 20:40:30) [MSC v.1500 64 bit (AMD64)]Thanks,Shakti SinghOn 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,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.ThanksShakti Singh
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
Neel Patel
On Wed, Dec 21, 2016 at 7:15 PM, Shakti Singh <shakti.0123@gmail.com> wrote:
Hi,Is there anyway or workaround this issue?Thanks,Shakti SinghOn Thu, Dec 15, 2016 at 8:31 AM, Shakti Singh <shakti.0123@gmail.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 nameThe query "select * from "schema1"."utils.Get_datetime"('02/02/2016 02:22:35');" returns the correct result. OS Version: Windows 2012 R2pgAdmin 4 Version: Version1.1Python Version: 2.7.11 (v2.7.11:6d1b6a68f775, Dec 5 2015, 20:40:30) [MSC v.1500 64 bit (AMD64)]Thanks,Shakti SinghOn 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,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.ThanksShakti Singh