Thread: Bug in PgAdmin III Query
Hi,
on Linux i cannot open the attached SQL-File in the "PgAdmin III Query". On Windows (XP) there are no problems.
I choose the directory (nfs-mounted) and then the file. On "open" the file selection box closes, but nothing happens.
Other sql-Files from the same directory can be opened! The file was created on Windows. I dos2unix'ed it too - no change.
OS Version: openSuse (10.2), 64 bit, Kernel: 2.6.18.2-34-default
PgAdmin III Version: 1.6.3
Sincerly
_______________________________________________________
Dr. Andreas Kutschke
e-mail: Andreas.Kutschke@edag.de
Tel: +49 0661/6000-787
Fax: +49 0661/6000-592(-11-1556)
Voice: +49 0661/6000-12-1556
_______________________________________________________
Court of jurisdiction: Amtsgericht Fulda, 5 HRB 1075 USt.-Id: DE 112402594
President and CEO: Dr. Klaus Blickle Chairman of the Supervisory Board: Dr. Lutz Helmig
Headquarters: EDAG Engineering + Design AG, Reesbergstraße 1, 36039 Fulda, Germany / www.edag.com
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
Attachment
Hi, Andreas Kutschke a écrit : > on Linux i cannot open the attached SQL-File in the "PgAdmin III Query". > On Windows (XP) there are no problems. > I choose the directory (nfs-mounted) and then the file. On "open" the > file selection box closes, but nothing happens. > Other sql-Files from the same directory can be opened! The same happens to me. I need to change it for UTF-8 encoding to be able to load it. Perhaps a warning message is required in this case ? Regards. -- Guillaume. <!-- http://abs.traduc.org/ http://lfs.traduc.org/ http://docs.postgresqlfr.org/ -->
Guillaume Lelarge wrote: > Hi, > > Andreas Kutschke a écrit : >> on Linux i cannot open the attached SQL-File in the "PgAdmin III Query". >> On Windows (XP) there are no problems. >> I choose the directory (nfs-mounted) and then the file. On "open" the >> file selection box closes, but nothing happens. >> Other sql-Files from the same directory can be opened! > > The same happens to me. I need to change it for UTF-8 encoding to be > able to load it. Perhaps a warning message is required in this case ? Can we automatically check for a BOM when opening the file,and use unicode mode automagically? /D
<br /><font face="sans-serif" size="2">Hi,</font><br /><br /><font face="sans-serif" size="2">- i set the preference "Readand write Unicode UTF-8 files" to true.</font><br /><font face="sans-serif" size="2"> It does not have any effet onthe program behaviour anyway.</font><br /><font face="sans-serif" size="2">- the operating system variables LANG and LC_*are all already set to "en_US.UTF-8".</font><br /><br /><font face="sans-serif" size="2">What shall i change more? vishows the german characters well!</font><br /><br /><br /><font size="2"><tt>Dave Page <dpage@postgresql.org> schriebam 01.06.2007 17:58:04:<br /><br /> > Guillaume Lelarge wrote:<br /> > > Hi,<br /> > > <br /> >> Andreas Kutschke a écrit :<br /> > >> on Linux i cannot open the attached SQL-File in the "PgAdmin IIIQuery".<br /> > >> On Windows (XP) there are no problems.<br /> > >> I choose the directory (nfs-mounted)and then the file. On "open" the<br /> > >> file selection box closes, but nothing happens.<br /> >>> Other sql-Files from the same directory can be opened!<br /> > > <br /> > > The same happens tome. I need to change it for UTF-8 encoding to be<br /> > > able to load it. Perhaps a warning message is requiredin this case ?<br /> > <br /> > Can we automatically check for a BOM when opening the file,and use<br /> >unicode mode automagically?<br /> > <br /> > /D<br /></tt></font>