Обсуждение: bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane
bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane
От
Gabriele Franch
Дата:
Hello, I'm using pgadmin 1.18.0 Alpha 1 (compiled from http://ftp.postgresql.org/pub/pgadmin3/release/v1.18.0-alpha1/src/pgadmin3-1.18.0-alpha1.tar.gz). Messages are repeated multiple times in messages pane. Version 1.16.1 does not expose this behavior. Example SQL: DROP FUNCTION IF EXISTS raise_something () CASCADE; CREATE OR REPLACE FUNCTION raise_something () RETURNS VOID AS $BODY$ BEGIN RAISE WARNING 'Something'; RAISE NOTICE 'Something else'; END $BODY$ LANGUAGE plpgsql; select * from raise_something(); Gabriele Franch
same bug when use vacuum feature 2013/5/16 Gabriele Franch <franch@fbk.eu>: > Hello, > I'm using pgadmin 1.18.0 Alpha 1 (compiled from > http://ftp.postgresql.org/pub/pgadmin3/release/v1.18.0-alpha1/src/pgadmin3-1.18.0-alpha1.tar.gz). > > Messages are repeated multiple times in messages pane. Version 1.16.1 > does not expose this behavior. > > Example SQL: > > DROP FUNCTION IF EXISTS raise_something () CASCADE; > CREATE OR REPLACE FUNCTION raise_something () > RETURNS VOID AS > $BODY$ > BEGIN > RAISE WARNING 'Something'; > RAISE NOTICE 'Something else'; > END > $BODY$ > LANGUAGE plpgsql; > > select * from raise_something(); > > Gabriele Franch > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support -- All bugs reserved
Вложения
Re: bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane
От
Ashesh Vashi
Дата:
It could be because of the changes in pgThread, made to redesign the debugger.
I will investigate it.
Thanks for the report.
Hello,
I'm using pgadmin 1.18.0 Alpha 1 (compiled from
http://ftp.postgresql.org/pub/pgadmin3/release/v1.18.0-alpha1/src/pgadmin3-1.18.0-alpha1.tar.gz).
Messages are repeated multiple times in messages pane. Version 1.16.1
does not expose this behavior.
Example SQL:
DROP FUNCTION IF EXISTS raise_something () CASCADE;
CREATE OR REPLACE FUNCTION raise_something ()
RETURNS VOID AS
$BODY$
BEGIN
RAISE WARNING 'Something';
RAISE NOTICE 'Something else';
END
$BODY$
LANGUAGE plpgsql;
select * from raise_something();
Gabriele Franch
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
![](http://s.wisestamp.com/pixel.png?p=mozilla&v=2.0.3&t=1285751372076&u=4060523&e=777)
Ashesh - this appears to be related to the debugger changes. Can you take a look please? Thanks. On Thu, May 16, 2013 at 2:07 PM, Gabriele Franch <franch@fbk.eu> wrote: > Hello, > I'm using pgadmin 1.18.0 Alpha 1 (compiled from > http://ftp.postgresql.org/pub/pgadmin3/release/v1.18.0-alpha1/src/pgadmin3-1.18.0-alpha1.tar.gz). > > Messages are repeated multiple times in messages pane. Version 1.16.1 > does not expose this behavior. > > Example SQL: > > DROP FUNCTION IF EXISTS raise_something () CASCADE; > CREATE OR REPLACE FUNCTION raise_something () > RETURNS VOID AS > $BODY$ > BEGIN > RAISE WARNING 'Something'; > RAISE NOTICE 'Something else'; > END > $BODY$ > LANGUAGE plpgsql; > > select * from raise_something(); > > Gabriele Franch > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
seems that commit 140e8aee4cb5d423bb76ad81874e442d3e17b5c1 (Rewrite the debugger to resolve numerous known issues and instabilities mostly due to the threading code.) also broke ability to cancel query by pressing stop button in query editor 2013/5/16 Dave Page <dpage@pgadmin.org>: > Ashesh - this appears to be related to the debugger changes. Can you > take a look please? > > Thanks. > > On Thu, May 16, 2013 at 2:07 PM, Gabriele Franch <franch@fbk.eu> wrote: >> Hello, >> I'm using pgadmin 1.18.0 Alpha 1 (compiled from >> http://ftp.postgresql.org/pub/pgadmin3/release/v1.18.0-alpha1/src/pgadmin3-1.18.0-alpha1.tar.gz). >> >> Messages are repeated multiple times in messages pane. Version 1.16.1 >> does not expose this behavior. >> >> Example SQL: >> >> DROP FUNCTION IF EXISTS raise_something () CASCADE; >> CREATE OR REPLACE FUNCTION raise_something () >> RETURNS VOID AS >> $BODY$ >> BEGIN >> RAISE WARNING 'Something'; >> RAISE NOTICE 'Something else'; >> END >> $BODY$ >> LANGUAGE plpgsql; >> >> select * from raise_something(); >> >> Gabriele Franch >> >> -- >> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgadmin-support > > > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > > -- > Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgadmin-support -- All bugs reserved
Re: bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane
От
Ashesh Vashi
Дата:
Thanks Timon for point out.
I already know about this - I've made that mistake and will resolve it very soon.
Made some changes in pgQueryThread class, which leads to this bug.
Actually - I was busy with some other stuff, and couldn't spend time on pgadmin3.
Actually - I was busy with some other stuff, and couldn't spend time on pgadmin3.
On Tue, Jun 18, 2013 at 2:05 PM, Timon <timosha@gmail.com> wrote:
--seems that commit 140e8aee4cb5d423bb76ad81874e442d3e17b5c1 (Rewrite
the debugger to resolve numerous known issues and instabilities mostly
due to the threading code.) also broke ability to cancel query by
pressing stop button in query editor
2013/5/16 Dave Page <dpage@pgadmin.org>:All bugs reserved> Ashesh - this appears to be related to the debugger changes. Can you
> take a look please?
>
> Thanks.
>
> On Thu, May 16, 2013 at 2:07 PM, Gabriele Franch <franch@fbk.eu> wrote:
>> Hello,
>> I'm using pgadmin 1.18.0 Alpha 1 (compiled from
>> http://ftp.postgresql.org/pub/pgadmin3/release/v1.18.0-alpha1/src/pgadmin3-1.18.0-alpha1.tar.gz).
>>
>> Messages are repeated multiple times in messages pane. Version 1.16.1
>> does not expose this behavior.
>>
>> Example SQL:
>>
>> DROP FUNCTION IF EXISTS raise_something () CASCADE;
>> CREATE OR REPLACE FUNCTION raise_something ()
>> RETURNS VOID AS
>> $BODY$
>> BEGIN
>> RAISE WARNING 'Something';
>> RAISE NOTICE 'Something else';
>> END
>> $BODY$
>> LANGUAGE plpgsql;
>>
>> select * from raise_something();
>>
>> Gabriele Franch
>>
>> --
>> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgadmin-support
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
Re: bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane
От
Ashesh Vashi
Дата:
Hi Timon,
I've sent patch to Dave (and, pgadmin-hackers) and he already checked-in.
Can you please confirm both the behavior with the latest code?
(1. Repeated messages and 2. Cancellation on Query Execution)
If you can spend some time, that will be very helpful.
On Tue, Jun 18, 2013 at 2:16 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
--Thanks Timon for point out.I already know about this - I've made that mistake and will resolve it very soon.Made some changes in pgQueryThread class, which leads to this bug.
Actually - I was busy with some other stuff, and couldn't spend time on pgadmin3.On Tue, Jun 18, 2013 at 2:05 PM, Timon <timosha@gmail.com> wrote:seems that commit 140e8aee4cb5d423bb76ad81874e442d3e17b5c1 (Rewrite
the debugger to resolve numerous known issues and instabilities mostly
due to the threading code.) also broke ability to cancel query by
pressing stop button in query editor
2013/5/16 Dave Page <dpage@pgadmin.org>:All bugs reserved> Ashesh - this appears to be related to the debugger changes. Can you
> take a look please?
>
> Thanks.
>
> On Thu, May 16, 2013 at 2:07 PM, Gabriele Franch <franch@fbk.eu> wrote:
>> Hello,
>> I'm using pgadmin 1.18.0 Alpha 1 (compiled from
>> http://ftp.postgresql.org/pub/pgadmin3/release/v1.18.0-alpha1/src/pgadmin3-1.18.0-alpha1.tar.gz).
>>
>> Messages are repeated multiple times in messages pane. Version 1.16.1
>> does not expose this behavior.
>>
>> Example SQL:
>>
>> DROP FUNCTION IF EXISTS raise_something () CASCADE;
>> CREATE OR REPLACE FUNCTION raise_something ()
>> RETURNS VOID AS
>> $BODY$
>> BEGIN
>> RAISE WARNING 'Something';
>> RAISE NOTICE 'Something else';
>> END
>> $BODY$
>> LANGUAGE plpgsql;
>>
>> select * from raise_something();
>>
>> Gabriele Franch
>>
>> --
>> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgadmin-support
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
i have tested it already, and it works great. Both problems are solved.
Thank you for your work :)
Thank you for your work :)
2013/6/20 Ashesh Vashi <ashesh.vashi@enterprisedb.com>
Hi Timon,I've sent patch to Dave (and, pgadmin-hackers) and he already checked-in.Can you please confirm both the behavior with the latest code?(1. Repeated messages and 2. Cancellation on Query Execution)If you can spend some time, that will be very helpful.On Tue, Jun 18, 2013 at 2:16 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:--Thanks Timon for point out.I already know about this - I've made that mistake and will resolve it very soon.Made some changes in pgQueryThread class, which leads to this bug.
Actually - I was busy with some other stuff, and couldn't spend time on pgadmin3.On Tue, Jun 18, 2013 at 2:05 PM, Timon <timosha@gmail.com> wrote:seems that commit 140e8aee4cb5d423bb76ad81874e442d3e17b5c1 (Rewrite
the debugger to resolve numerous known issues and instabilities mostly
due to the threading code.) also broke ability to cancel query by
pressing stop button in query editor
2013/5/16 Dave Page <dpage@pgadmin.org>:All bugs reserved> Ashesh - this appears to be related to the debugger changes. Can you
> take a look please?
>
> Thanks.
>
> On Thu, May 16, 2013 at 2:07 PM, Gabriele Franch <franch@fbk.eu> wrote:
>> Hello,
>> I'm using pgadmin 1.18.0 Alpha 1 (compiled from
>> http://ftp.postgresql.org/pub/pgadmin3/release/v1.18.0-alpha1/src/pgadmin3-1.18.0-alpha1.tar.gz).
>>
>> Messages are repeated multiple times in messages pane. Version 1.16.1
>> does not expose this behavior.
>>
>> Example SQL:
>>
>> DROP FUNCTION IF EXISTS raise_something () CASCADE;
>> CREATE OR REPLACE FUNCTION raise_something ()
>> RETURNS VOID AS
>> $BODY$
>> BEGIN
>> RAISE WARNING 'Something';
>> RAISE NOTICE 'Something else';
>> END
>> $BODY$
>> LANGUAGE plpgsql;
>>
>> select * from raise_something();
>>
>> Gabriele Franch
>>
>> --
>> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgadmin-support
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
--Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
--
All bugs reserved
Re: bug: repeated messages in pgadmin (1.18.0 Alpha 1) query tool messages pane
От
Ashesh Vashi
Дата:
On Fri, Jun 21, 2013 at 10:11 AM, Timon <timosha@gmail.com> wrote:
--
--
i have tested it already, and it works great. Both problems are solved.
Thank you for your work :)
Thanks a lot.
That's a relief for me. :-)
--2013/6/20 Ashesh Vashi <ashesh.vashi@enterprisedb.com>Hi Timon,I've sent patch to Dave (and, pgadmin-hackers) and he already checked-in.Can you please confirm both the behavior with the latest code?(1. Repeated messages and 2. Cancellation on Query Execution)If you can spend some time, that will be very helpful.On Tue, Jun 18, 2013 at 2:16 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:--Thanks Timon for point out.I already know about this - I've made that mistake and will resolve it very soon.Made some changes in pgQueryThread class, which leads to this bug.
Actually - I was busy with some other stuff, and couldn't spend time on pgadmin3.On Tue, Jun 18, 2013 at 2:05 PM, Timon <timosha@gmail.com> wrote:seems that commit 140e8aee4cb5d423bb76ad81874e442d3e17b5c1 (Rewrite
the debugger to resolve numerous known issues and instabilities mostly
due to the threading code.) also broke ability to cancel query by
pressing stop button in query editor
2013/5/16 Dave Page <dpage@pgadmin.org>:All bugs reserved> Ashesh - this appears to be related to the debugger changes. Can you
> take a look please?
>
> Thanks.
>
> On Thu, May 16, 2013 at 2:07 PM, Gabriele Franch <franch@fbk.eu> wrote:
>> Hello,
>> I'm using pgadmin 1.18.0 Alpha 1 (compiled from
>> http://ftp.postgresql.org/pub/pgadmin3/release/v1.18.0-alpha1/src/pgadmin3-1.18.0-alpha1.tar.gz).
>>
>> Messages are repeated multiple times in messages pane. Version 1.16.1
>> does not expose this behavior.
>>
>> Example SQL:
>>
>> DROP FUNCTION IF EXISTS raise_something () CASCADE;
>> CREATE OR REPLACE FUNCTION raise_something ()
>> RETURNS VOID AS
>> $BODY$
>> BEGIN
>> RAISE WARNING 'Something';
>> RAISE NOTICE 'Something else';
>> END
>> $BODY$
>> LANGUAGE plpgsql;
>>
>> select * from raise_something();
>>
>> Gabriele Franch
>>
>> --
>> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgadmin-support
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
--Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
All bugs reserved
--
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company
![](http://s.wisestamp.com/pixel.png?p=mozilla&v=2.0.3&t=1285751372076&u=4060523&e=777)