Bug: Opening pgAdmin with a file with mixed line endings - Mailing list pgadmin-support

From Matthew Pava
Subject Bug: Opening pgAdmin with a file with mixed line endings
Date
Msg-id 1066221d8e184e659001353f32f51190@ISS1.ISS.LOCAL
Whole thread Raw
List 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.pava@iss.com

 

pgadmin-support by date:

Previous
From: Михаил Гаврилов
Date:
Subject: pgadmin eat all symbols after LIMIT statement when transfer part of line to new line
Next
From: Mark Csaba
Date:
Subject: Re: Bug: Opening pgAdmin with a file with mixed line endings