> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
