Re: [HACKERS] Database names with spaces

Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> writes:
> Looks like a bug. Added to TODO list.

>> I see a todo item
>> * Views with spaces in view name fail when referenced
>>
>> I have another one for you:
>> * Databases with spaces in name fail to be created and destroyed despite
>> responses to the contrary.

IIRC, createdb and destroydb use "cp -r" and "rm -r" respectively.
Lack of careful quoting in the system calls is probably what's
causing the problem here.

However, I wonder if it wouldn't be a better idea to forbid funny
characters in things that will become Unix filenames. In particular,
something like CREATE DATABASE "../../../something" could have real
bad consequences...

regards, tom lane