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

["Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>]

 

---

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||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.