Bug: Opening pgAdmin with a file with mixed line endings

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

Browse pgadmin-support by date

  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