Re: pg_dumpall: does not exist database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dumpall: does not exist database
Дата
Msg-id 13913.1145951194@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dumpall: does not exist database  (Ari Kahn <akahn1@gmu.edu>)
Список pgsql-general
Ari Kahn <akahn1@gmu.edu> writes:
> On Apr 25, 2006, at 3:25 AM, Tom Lane wrote:
>> If so, I'm wondering if you've got a database with a carriage return
>> embedded in the name, or something like that.

> That was a good idea. But this is not the case.
> postgres=# drop database "\n";
> ERROR:  database "\n" does not exist
> postgres=# drop database "\r";
> ERROR:  database "\r" does not exist

Those tests have little to do with what I'm worried about.  Backslash
isn't an escape character in SQL names, and even if it were, your tests
only checked for databases named exactly "one newline" or "one carriage
return", not for names comprising those characters along with others.

            regards, tom lane

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

Предыдущее
От: Ari Kahn
Дата:
Сообщение: Re: pg_dumpall: does not exist database
Следующее
От: "SunWuKung"
Дата:
Сообщение: Re: isnumeric - checking if text variable is convertable to numeric