Re: Crashes in Query Window - PgAdmin 1.6 Beta SVN Head - Mailing list pgadmin-support

From Dave Page
Subject Re: Crashes in Query Window - PgAdmin 1.6 Beta SVN Head
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40176CED9@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Crashes in Query Window - PgAdmin 1.6 Beta SVN Head  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
Responses Re: Crashes in Query Window - PgAdmin 1.6 Beta SVN Head
List pgadmin-support
 


From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Harald Armin Massa
Sent: 20 September 2006 10:59
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Crashes in Query Window - PgAdmin 1.6 Beta SVN Head

Hello,

I am using a kindly-by-Dave-provided PgAdmin 1.6 Beta from SVN Head as of 2006-09-19 9:07.

Within the Query Window I am developping a query:

select md5(id_rf::text||coalesce(wert,'x')||id_rk::text||id_bf), * from repofeld   <F5>

select md5(id_rf::text||coalesce(wert,'x')||id_rk::text||id_bf||anothercol1), * from repofeld  <F5>
select md5(id_rf::text||coalesce(wert,'x')||id_rk::text||id_bf||anothercol1||anothercol2), * from repofeld  <F5>

[....]

and after around 20-30 runs of this query, PgAdmin "hard crashes" (phone home to MS type of crash)

As much as I am able to analyze, it happens after numerous queries containing "no real colums" -> that md5(whatever) is ?column? in output, and everytime a different result - as I am developing this function (learning where I have to cast by hand etc...)

Can it be that the "caching of column heads" could be responsible in some way, Dave?
 
Unlikely, as all it's doing is storing the data in an array after the first retrieval. Why do you think that though - did it work in the earlier version?
 
Regards, Dave.

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: pgAgent Job never starts
Next
From: "Harald Armin Massa"
Date:
Subject: Re: Crashes in Query Window - PgAdmin 1.6 Beta SVN Head