Search Postgresql Archives

Re: pg_dumpall: does not exist database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ari Kahn <akahn1@xxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux