Re: Infinite loop occurs sometimes when exporting

Hi Dave,

Rebooting did not help.

I will send you something directly.

Mike

On Fri, 05 Jan 2007 09:22:23 +0000, Dave Page wrote
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--
Open WebMail Project (http://openwebmail.org)