From: | Matthew Pava <Matthew(dot)Pava(at)iss(dot)com> |
---|---|
To: | "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Bug: Opening pgAdmin with a file with mixed line endings |
Date: | 2016-07-13 20:06:07 |
Message-ID: | 1066221d8e184e659001353f32f51190@ISS1.ISS.LOCAL |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Running pgAdmin Version 1.22.1 (Feb 9, 2016, rev: REL-1_22_1) on Windows 10 Pro
I am opening a file that has mixed line endings. When I open it through the pgAdmin interface Query window, I receive the following Warning dialog: "The file contains mixed line endings. They will be converted to the current setting." There is an OK button that I press and all is well.
However, I am trying to open it through the command line with this command:
pgAdmin3 /s "server-name" /q /f filename.sql
My credentials to the database are saved. Whenever I run that command on files that do not have mixed line endings, I am able to execute the SQL file simply by clicking the execute button. However, when the file has mixed line endings, the warning dialog is covered by the pgAdmin splash screen (the cute elephant), and it is somewhat of a challenge to find the dialog to click through it. I have learned to simply press the Enter the key when I hear the warning dialog sound coming from my speakers.
Thank you,
Matthew Pava
System Administrator/Database Programmer
ISS
1602 Newton Dr
Champaign, IL 61822
Tel: 217-359-8681
mailto:matthew(dot)pava(at)iss(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Csaba | 2016-07-13 21:26:07 | Re: Bug: Opening pgAdmin with a file with mixed line endings |
Previous Message | Михаил Гаврилов | 2016-07-13 06:22:22 | pgadmin eat all symbols after LIMIT statement when transfer part of line to new line |