Re: Infinite loop occurs sometimes when exporting

Mike G wrote:
> Hello,

Hi Mike,

> I had pgadmin logging set to debug which hopefully will help.  I have attached the log.
>  I  initially had opened up a query window, wrote a query, ran it, exported it, opened
> up the output file in Excel, and then realized that I needed an additional column.
> 
> I then closed the spreadsheet but I did not completely close Excel.  I modified the query
> which required adding another join to get the column.  I then ran the query and then
> attempted to export the results to a file.  Pgadmin went into an infinite loop.
> 
> The first query was "SELECT DISTINCT * FROM TABLE"
> 
> The second query was "SELECT DISTINCT a.*, b.missing FROM TABLE A INNER JOIN TABLE2 B ON
> B.col = A.col"
> 
> I have had to force pgadmin to shutdown to kill the race.  
> 
> I reopened pgadmin, did the above again, and pgadmin again went into a loop.
> 
> Perhaps rebooting will fix the issue but the detail in the log file makes me think it won't.

Yes, agreed.

> pgadmin 1.6.1, XP SP2, postgres 8.2

Much as I've tried, I just cannot reproduce this. Can you create a self
contained test case that I can play with? (tables, data etc.)

Thanks, Dave.