getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote

Поиск
Список
Период
Сортировка
От Mahendra Singh Thalor
Тема getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote
Дата
Msg-id CAKYtNApkOi4FY0S7+3jpTqnHVyyZ6Tbzhtbah-NBbY-mGsiKAQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote
Список pgsql-hackers
Hi,
While doing some testing with pg_dumpall, I noticed one weird behaviour.

While we create the database, we are allowing the database name with a new line (if name is in double quote).
For example:
postgres=# create database "dbstr1;
dbstr 2";
CREATE DATABASE
postgres=#
Here, the database name is in 2 lines.

With the help of pg_dumpall, I tried to dump but I am getting an error for the new line.

--
-- Database "dbstr1;
dbstr 2" dump
--

shell command argument contains a newline or carriage return: " dbname='dbstr1;
dbstr 2'"
 
After this message, we are stopping the dump.

I think, if we are allowing new lines in the db name, then we should dump it.

Please let me know your thoughts about this error. 

--
Thanks and Regards
Mahendra Singh Thalor
EnterpriseDB: http://www.enterprisedb.com

В списке pgsql-hackers по дате отправления: