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*
