Re: Exporting results from query window to a file

mike wrote:
> Hello,
> 
> Has something changed from 1.4 to 1.6 in how pgadmin exports files?  In
> 1.6 RC1 I have had issues when exporting the results of a query to a
> file that
>  A) I get the dialog box that says the Export completed sucessfully
>  B) Upon opening the file I find it is damaged because the results were
> not completely exported.  Maybe on row 66 the end of the line is not
> present.  The file should have had over 100 rows. 
>  C) Running it again from the same query window the results noted in A
> and B occur again but the actual number of rows written to the file are
> completely different. Usually a fewer amount of rows get exported.
>  D) Copying and pasting the same query into a new query window, running
> the query, and then exporting the data works successfully.
> 
> I have a co-worker who also had the same problems with the final release
> of 1.6.
> 
> I have not tried 1.6.1 but it didn't appear that the changes made
> between 1.6.1 and 1.6 would have affected this.
> 
> Client platform is WinXP SP2 and Database platform is Win2003.
> 
> I cannot reproduce this consistently.

There were some changes to check that data was converted to the correct 
encoding correctly, and to correct a race issue over slow networks where 
the data export may complete before all the data has actually been 
retrieved from the server.

How are you executing the export - from the file menu on the query tool? 
What encoding are you using?

Is there a small dataset that fails often enough that you could package 
it as a test case for me to look at?

Regards, Dave