From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Ari Kahn <akahn1(at)gmu(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_dumpall: does not exist database |
Date: | 2006-04-25 07:46:34 |
Message-ID: | 13913.1145951194@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ari Kahn <akahn1(at)gmu(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | SunWuKung | 2006-04-25 09:01:49 | Re: isnumeric - checking if text variable is convertable to numeric |
Previous Message | Ari Kahn | 2006-04-25 07:35:22 | Re: pg_dumpall: does not exist database |