Re: Bug: Missing tuples in results written to file

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Erwin Brandstetter
> Sent: 17 October 2006 02:05
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Bug: Missing tuples in results
> written to file
>
> Hi developers!
>
> I am testing pgAdmin III Beta 3 (Oct 12 2006, re: 5475) on Windows XP
> (German, latest patch level).
>
> When I try to use the feature "Execute Query, write result to
> file" in
> the SQL dialogue window, the result is wrong half of the time.
> Tried it many times. Sometimes the results are correct,
> sometimes not.
> Seems to happen at random. This is what happens:
> Leading column names are there (as requested). Then some of the first
> tuples are missing. Instead, the same number of lines with
> only column
> separators (empty tuples?) is appended at the end.
> pgAdmin invariably reports a success "Data export completed
> successfully".
> The results of the same query are never wrong in the output pane.

I cannot reproduce this here, so if I can ask a few questions...

1) What encoding is your database in?

2) What encoding are you saving the data in? Have you tried both
options? (Local and UTF-8)

3) Can you provide a sample table with which you can reproduce the
problem that I can test with?

BTW, I'm away for a few days from tomorrow so may not answer
immediately.

Thanks, Dave.