From: | "Mike G" <mike(at)thegodshalls(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Infinite loop occurs sometimes when exporting query to a file, 1.6.1 |
Date: | 2007-01-02 20:21:18 |
Message-ID: | 20070102200957.M45246@thegodshalls.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hello,
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.
pgadmin 1.6.1, XP SP2, postgres 8.2
--
Open WebMail Project (http://openwebmail.org)
Attachment | Content-Type | Size |
---|---|---|
pgadmin.zip | application/x-zip-compressed | 16.5 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Ryan Ollerenshaw | 2007-01-03 01:54:55 | pgAdmin Install |
Previous Message | Tala Halaseh | 2007-01-01 18:07:10 | unsubscribe |