From: | Dave Page <dpage(at)postgresql(dot)org> |
---|---|
To: | mike(at)thegodshalls(dot)com |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Infinite loop occurs sometimes when exporting |
Date: | 2007-01-05 09:22:23 |
Message-ID: | 459E18CF.1000408@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-01-05 09:39:18 | Re: Delete icon deletes all records in pgadmin |
Previous Message | Oliver Baden | 2007-01-04 19:52:01 | Delete icon deletes all records in pgadmin 1.61 |