On Tue, Oct 29, 2013 at 7:17 PM, Akshay Joshi <akshay.jo...@enterprisedb.com > wrote:
> Hi Ashesh > > I have tested this issue on Windows 7 64 bit and Windows 8. I am able to > reproduce the issue on Windows 8, but not able to reproduce it on Windows > 7. I haven't open the second instance of the pgAdmin. I have followed the > steps mentioned in the email, instead of opening the second instance of the > pgAdmin, I have tried with the same instance and with the help of query > tool I have insert the values in the table. > > This bug is reproducible only when Play button from the toolbar is > pressed, it works with F5 key. First time I am able to debug the function > but when I pressed the play button then onwards not able to debug, > execution marker is not visible but it stops at the first line of the > function and all the toolbar option is disabled on the debugger window, so > we can't do anything. Status bar of the query tool is showing query is > running. > Thanks. In that case - we need to create a development environment on windows 8 and see what's going wrong. Can you please do it for us (when time permits)? > > > On Tue, Oct 29, 2013 at 4:34 PM, Akshay Joshi < > akshay.jo...@enterprisedb.com> wrote: > >> Ok. Will try that >> >> >> On Tue, Oct 29, 2013 at 3:55 PM, Ashesh Vashi < >> ashesh.va...@enterprisedb.com> wrote: >> >>> Akshay, >>> >>> Can you also try? >>> On 29 Oct 2013 14:17, "EDUARDO ESTEBAN" <edua...@deisa.net> wrote: >>> >>>> ** >>>> I don´t really know what to say. I have made the same test several >>>> times on 2 different computers (one with Windows 7 Pro and another one with >>>> Windows 8) and both fails. >>>> I am using PostgreSQL 9.3.1-1 and pgAdmin 1.18.1 >>>> >>>> Thank you. >>>> >>>> >>>> ------------------------------ >>>> *De:* Ashesh Vashi [mailto:ashesh.va...@enterprisedb.com] >>>> *Enviado el:* martes, 29 de octubre de 2013 7:50 >>>> *Para:* EDUARDO ESTEBAN >>>> *CC:* pgadmin-support >>>> *Asunto:* Re: [pgadmin-support] pgAdmin debugger hangs on Windows 8 >>>> after closing debug window >>>> >>>> On Mon, Oct 28, 2013 at 11:36 PM, EDUARDO ESTEBAN >>>> <edua...@deisa.net>wrote: >>>> >>>>> ** >>>>> Try to push the play button on the toolbar insted of pressing F5 Key... >>>>> With F5 worked but noy when pressing the play button (wich should be >>>>> equivalent). >>>>> >>>> Both are same, same function is attached to both events. >>>> >>>>> >>>>> Thank you >>>>> >>>>> ------------------------------ >>>>> *De:* Ashesh Vashi [mailto:ashesh.va...@enterprisedb.com] >>>>> *Enviado el:* lunes, 28 de octubre de 2013 18:57 >>>>> >>>>> *Para:* EDUARDO ESTEBAN >>>>> *CC:* pgadmin-support >>>>> *Asunto:* Re: [pgadmin-support] pgAdmin debugger hangs on Windows 8 >>>>> after closing debug window >>>>> >>>>> On Mon, Oct 28, 2013 at 10:51 PM, EDUARDO ESTEBAN <edua...@deisa.net >>>>> > wrote: >>>>> >>>>>> ** >>>>>> Thank you for your fast answer. >>>>>> I don´t know what you exactly mean by session, but please let me >>>>>> resume the steps to reproduce the problem: >>>>>> >>>>>> 1- To test it, use the example (database, table and trigger function >>>>>> y supplied) >>>>>> 2- Open one pgAdmin (we call this pgAdmin 1) and "set breakpoint" >>>>>> on the trigger function isql_country_b_trigger. >>>>>> 3- Open another pgAdmin (we call this pgAdmin 2) and insert a >>>>>> record in the COUNTRY_COU table (only the cou_id field is mandatory) >>>>>> 3- On pgAdmin 1 you will see that the debugger is waiting..., press F5 >>>>>> and don´t close any window >>>>>> 4- On pgAdmin 2 insert a new record in the COUNTRY_COU table >>>>>> 5- pgAdmin 2 is frozen and pgAdmin 1 is not sttoped in de debug >>>>>> window as it was on step 3. >>>>>> >>>>> Unfortunately - I am not able reproduce the scenario. >>>>> I tried multiple times and multiple ways without luck... >>>>> >>>>>> >>>>>> Regards. >>>>>> Eduardo Esteban >>>>>> >>>>>> ------------------------------ >>>>>> *De:* Ashesh Vashi [mailto:ashesh.va...@enterprisedb.com] >>>>>> *Enviado el:* lunes, 28 de octubre de 2013 17:59 >>>>>> >>>>>> *Para:* EDUARDO ESTEBAN >>>>>> *CC:* pgadmin-support >>>>>> *Asunto:* Re: [pgadmin-support] pgAdmin debugger hangs on Windows 8 >>>>>> after closing debug window >>>>>> >>>>>> Do mean to say that - the debugger does not remember the >>>>>> break-points for two different sessions? >>>>>> Then yes - it is not remembering them at the moment. >>>>>> I will send a patch to resolve the issue soon. >>>>>> >>>>>> >>>>>> On Mon, Oct 28, 2013 at 9:14 PM, EDUARDO ESTEBAN >>>>>> <edua...@deisa.net>wrote: >>>>>> >>>>>>> ** >>>>>>> Dear Ashesh, >>>>>>> I told you that the pgAdmin debug was working on 9.3.1.-1 but making >>>>>>> a deeper test it doesn´t work well at all. >>>>>>> Once a breakpoint is reached, if F5 key is pressed (to continue) if >>>>>>> the breakpoint is reached later again then it doesn´t stop on the >>>>>>> debuggged >>>>>>> function but at the same time the function doesn´t continue with the >>>>>>> execution (it seems that the breakpoint is reached but it doesn´t show >>>>>>> up >>>>>>> and the xecution of the function is stopped) >>>>>>> You can try it with the same test example that i described on my >>>>>>> previous email. >>>>>>> >>>>>>> >>>>>>> Thank you in advance >>>>>>> Eduardo Esteban >>>>>>> >>>>>>> >>>>>>> >>>>>>> ------------------------------ >>>>>>> *De:* pgadmin-support-ow...@postgresql.org [mailto: >>>>>>> pgadmin-support-ow...@postgresql.org] *En nombre de *Ashesh Vashi >>>>>>> *Enviado el:* martes, 22 de octubre de 2013 19:40 >>>>>>> >>>>>>> *Para:* EDUARDO ESTEBAN >>>>>>> *CC:* pgadmin-support >>>>>>> *Asunto:* Re: [pgadmin-support] pgAdmin debugger hangs on Windows 8 >>>>>>> after closing debug window >>>>>>> >>>>>>> >>>>>>> On 22 Oct 2013 20:16, "EDUARDO ESTEBAN" <edua...@deisa.net> wrote: >>>>>>> > >>>>>>> > Dear Ashesh. >>>>>>> > I have tested the pgAdmin debugger with PostgreSQL 9.3.1 and it >>>>>>> works fine on Windows 8 x64. >>>>>>> Glad to hear that... >>>>>>> >>>>>>> -- Ashesh >>>>>>> > >>>>>>> > Thank you very much for your help. >>>>>>> > Regards. >>>>>>> > Eduardo Esteban >>>>>>> > >>>>>>> > ________________________________ >>>>>>> > De: pgadmin-support-ow...@postgresql.org [mailto: >>>>>>> pgadmin-support-ow...@postgresql.org] En nombre de Ashesh Vashi >>>>>>> > Enviado el: martes, 22 de octubre de 2013 15:49 >>>>>>> > >>>>>>> > Para: EDUARDO ESTEBAN >>>>>>> > CC: pgadmin-support >>>>>>> > Asunto: Re: [pgadmin-support] pgAdmin debugger hangs on Windows 8 >>>>>>> after closing debug window >>>>>>> > >>>>>>> > On Mon, Oct 21, 2013 at 8:12 PM, EDUARDO ESTEBAN < >>>>>>> edua...@deisa.net> wrote: >>>>>>> >> >>>>>>> >> Dear Ashesh, >>>>>>> >> Thank you for your fast answer. >>>>>>> >> It fails with any function or trigger that i have tested it >>>>>>> always on Windows 8 x64 and i have tested with several pgAdmin and >>>>>>> PostgreSQL versions on Windows 8. >>>>>>> >> Anyway here there are the details of the version and a example to >>>>>>> test. >>>>>>> >> PostgreSQL 9.2.4 on x64 >>>>>>> >> Compiled by Visual C++ build 1600 64 bit >>>>>>> >> >>>>>>> >> PGAdmin 1.16.1 April 2 2013 REV: REL-1_16_1 >>>>>>> > >>>>>>> > Hi, >>>>>>> > >>>>>>> > Thanks for the inputs... >>>>>>> > >>>>>>> > FYI - We've redesigned the debugger code completely in pgAdmin >>>>>>> 1.18. >>>>>>> > Unfortunately - we found a lot of design issues with debugger code >>>>>>> in older version, which couldn't be tracked and fixed, which forced us >>>>>>> to >>>>>>> redesign ti for the latest version. >>>>>>> > >>>>>>> > Please use the latest pgAdmin III (1.18.1) bundled with one-click >>>>>>> installer PostgreSQL 9.3.1 , or you can download it for windows from >>>>>>> this >>>>>>> link: >>>>>>> > http://www.postgresql.org/ftp/pgadmin3/release/v1.18.1/win32/ >>>>>>> > >>>>>>> > Can you please share your experience with the latest pgAdmin III? >>>>>>> >> >>>>>>> >> >>>>>>> >> PostgreSQL and pgAdmin are installed using the Windows installer >>>>>>> provided by Enterprisedb from the download page of postgresql.org >>>>>>> >> >>>>>>> >> The database coding by default is UTF8 but i change it to >>>>>>> WIN1252 once the database is created. >>>>>>> >> These are all the steps to reproduce the problem: >>>>>>> >> >>>>>>> >> -- CREATE DATABASE >>>>>>> >> CREATE DATABASE "i.TEST.2013.0" >>>>>>> >> WITH OWNER = postgres >>>>>>> >> TABLESPACE = pg_default >>>>>>> >> LC_COLLATE = 'Spanish_Spain.1252' >>>>>>> >> LC_CTYPE = 'Spanish_Spain.1252' >>>>>>> >> CONNECTION LIMIT = -1; >>>>>>> >> >>>>>>> >> --UPDATE DATABASE CODING >>>>>>> >> update "pg_catalog"."pg_database" set encoding=24 where >>>>>>> datname='i.TEST.2013.0' >>>>>>> >> >>>>>>> >> -- ACTIVATE DEBUGGER >>>>>>> >> CREATE EXTENSION pldbgapi; >>>>>>> >> >>>>>>> >> -- CREATE TABLE >>>>>>> >> CREATE TABLE "COUNTRY_COU" >>>>>>> >> ( >>>>>>> >> cou_id character varying(2) NOT NULL DEFAULT ''::character >>>>>>> varying, -- ID ISO 2 >>>>>>> >> cou_iso3 character varying(3), -- ISO 3 >>>>>>> >> cou_countryname character varying(100), -- País >>>>>>> >> cou_isocode integer, -- Cod. ISO >>>>>>> >> cou_flag bytea, -- Bandera >>>>>>> >> CONSTRAINT cou_id PRIMARY KEY (cou_id) -- ID ISO 2 >>>>>>> >> ) >>>>>>> >> WITH ( >>>>>>> >> OIDS=FALSE >>>>>>> >> ); >>>>>>> >> ALTER TABLE "COUNTRY_COU" >>>>>>> >> OWNER TO postgres; >>>>>>> >> >>>>>>> >> -- Index: cou_countryname >>>>>>> >> >>>>>>> >> -- DROP INDEX cou_countryname; >>>>>>> >> >>>>>>> >> CREATE UNIQUE INDEX cou_countryname >>>>>>> >> ON "COUNTRY_COU" >>>>>>> >> USING btree >>>>>>> >> (cou_countryname); >>>>>>> >> -- Index: cou_iso3 >>>>>>> >> >>>>>>> >> -- DROP INDEX cou_iso3; >>>>>>> >> >>>>>>> >> CREATE UNIQUE INDEX cou_iso3 >>>>>>> >> ON "COUNTRY_COU" >>>>>>> >> USING btree >>>>>>> >> (cou_iso3); >>>>>>> >> -- Index: cou_isocode >>>>>>> >> >>>>>>> >> -- DROP INDEX cou_isocode; >>>>>>> >> >>>>>>> >> CREATE UNIQUE INDEX cou_isocode >>>>>>> >> ON "COUNTRY_COU" >>>>>>> >> USING btree >>>>>>> >> (cou_isocode); >>>>>>> >> -- CREATE FUNCTION >>>>>>> >> CREATE OR REPLACE FUNCTION isql_country_b_trigger() >>>>>>> >> RETURNS trigger AS >>>>>>> >> $BODY$ >>>>>>> >> DECLARE >>>>>>> >> >>>>>>> >> BEGIN >>>>>>> >> IF (TG_OP = 'INSERT') OR (TG_OP = 'UPDATE') THEN >>>>>>> >> IF NEW.cou_id IS NULL THEN >>>>>>> >> RAISE 'cou_id is null' USING ERRCODE = '42000'; >>>>>>> >> END IF; >>>>>>> >> IF NEW.cou_iso3 IS NULL THEN >>>>>>> >> NEW.cou_iso3 = NEW.cou_id; >>>>>>> >> END IF; >>>>>>> >> IF NEW.cou_countryname IS NULL THEN >>>>>>> >> NEW.cou_countryname = NEW.cou_id; >>>>>>> >> END IF; >>>>>>> >> RETURN NEW; >>>>>>> >> ELSIF (TG_OP = 'DELETE') THEN >>>>>>> >> RETURN OLD; >>>>>>> >> ELSIF (TG_OP = 'UPDATE') THEN >>>>>>> >> RETURN NEW; >>>>>>> >> END IF; >>>>>>> >> RETURN NULL; >>>>>>> >> END; >>>>>>> >> $BODY$ >>>>>>> >> LANGUAGE plpgsql VOLATILE >>>>>>> >> COST 1000; >>>>>>> >> ALTER FUNCTION isql_country_b_trigger() >>>>>>> >> OWNER TO postgres; >>>>>>> >> --CREATE TRIGGER >>>>>>> >> CREATE TRIGGER isql_tri_0_b_iud_country_cou >>>>>>> >> BEFORE INSERT OR UPDATE OR DELETE >>>>>>> >> ON "COUNTRY_COU" >>>>>>> >> FOR EACH ROW >>>>>>> >> EXECUTE PROCEDURE isql_country_b_trigger(); >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>> >> Finally, to reproduce the problem open one pgAdmin Window to >>>>>>> debug the trigger function. >>>>>>> >> >>>>>>> >> Open another pgAdmin Window and insert a record on the table. >>>>>>> >> >>>>>>> >> When the debug Window is closed then the pgAdmin freezes and it >>>>>>> should be closed from the task manager. >>>>>>> >> >>>>>>> >> >>>>>>> >> Thank you in advance >>>>>>> >> Eduardo Esteban >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>> >> ________________________________ >>>>>>> >> De: pgadmin-support-ow...@postgresql.org [mailto: >>>>>>> pgadmin-support-ow...@postgresql.org] En nombre de Ashesh Vashi >>>>>>> >> Enviado el: lunes, 21 de octubre de 2013 13:08 >>>>>>> >> Para: EDUARDO ESTEBAN >>>>>>> >> CC: pgadmin-support >>>>>>> >> Asunto: Re: [pgadmin-support] pgAdmin debugger hangs on Windows 8 >>>>>>> after closing debug window >>>>>>> >> >>>>>>> >> Hi Eduardo Esteban, >>>>>>> >> >>>>>>> >> Can you please share the pl/pgsql for debugging? >>>>>>> >> (We require that to understand the function structure. i.e. >>>>>>> return values, arguments, etc.) >>>>>>> >> >>>>>>> >> We will also require following information: >>>>>>> >> 1. pgAdmin III version >>>>>>> >> 2. OS version >>>>>>> >> 3. Database server version >>>>>>> >> >>>>>>> >> NOTE: A step by step reproduction steps will be very helpful. >>>>>>> >> >>>>>>> >> On Mon, Oct 21, 2013 at 4:25 PM, EDUARDO ESTEBAN < >>>>>>> edua...@deisa.net> wrote: >>>>>>> >>> >>>>>>> >>> Hi, >>>>>>> >>> When using the debugger in pgAdmin on Windows 8 debugging any >>>>>>> pl/pgsql funtion it hangs and the pgAdmin should be close from the task >>>>>>> manager. >>>>>>> >>> This only happens on whatever version of pgAdmin used on Windows >>>>>>> 8 64 bits (for example pgAdmin 1.18.0). >>>>>>> >>> To reproduce the problem try to debug a pl/pgsql function and >>>>>>> after the debug window shows, try to close the debug window and you will >>>>>>> see that the pgAdmin hangs and it should be restarted. >>>>>>> >>> >>>>>>> >>> Thank you in advance. >>>>>>> >>> Eduardo Esteban >>>>>>> >>> >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>> >> -- >>>>>>> >> -- >>>>>>> >> >>>>>>> >> Thanks & Regards, >>>>>>> >> >>>>>>> >> Ashesh Vashi >>>>>>> >> EnterpriseDB INDIA: Enterprise PostgreSQL Company >>>>>>> >> >>>>>>> >> >>>>>>> >> >>>>>>> >> http://www.linkedin.com/in/asheshvashi >>>>>>> > >>>>>>> > -- >>>>>>> > >>>>>>> > Thanks & Regards, >>>>>>> > >>>>>>> > Ashesh Vashi >>>>>>> > EnterpriseDB INDIA: Enterprise PostgreSQL Company >>>>>>> > >>>>>>> > >>>>>>> > http://www.linkedin.com/in/asheshvashi >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> -- >>>>>> >>>>>> Thanks & Regards, >>>>>> >>>>>> Ashesh Vashi >>>>>> EnterpriseDB INDIA: Enterprise PostgreSQL >>>>>> Company<http://www.enterprisedb.com> >>>>>> >>>>>> >>>>>> >>>>>> *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi> >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> -- >>>>> >>>>> Thanks & Regards, >>>>> >>>>> Ashesh Vashi >>>>> EnterpriseDB INDIA: Enterprise PostgreSQL >>>>> Company<http://www.enterprisedb.com> >>>>> >>>>> >>>>> >>>>> *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi> >>>>> >>>> >>>> >>>> >>>> -- >>>> -- >>>> >>>> Thanks & Regards, >>>> >>>> Ashesh Vashi >>>> EnterpriseDB INDIA: Enterprise PostgreSQL >>>> Company<http://www.enterprisedb.com> >>>> >>>> >>>> >>>> *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi> >>>> >>> >> >> >> -- >> *Akshay Joshi* >> *Principal Software Engineer * >> * >> * >> ** >> * >> * >> *Phone: +91 20-3058-9517 >> Mobile: +91 976-788-8246* >> > > > > -- > *Akshay Joshi* > *Principal Software Engineer * > * > * > ** > * > * > *Phone: +91 20-3058-9517 > Mobile: +91 976-788-8246* > -- -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company<http://www.enterprisedb.com> *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi>
