Re: Crashes in Query Window - PgAdmin 1.6 Beta SVN Head

________________________________

From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Harald Armin
Massa
Sent: 20 September 2006 10:59
To: pgadmin-support(at)postgresql(dot)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||an
othercol2), * 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.