Ann W. Harrison wrote:
> Kevin wrote:
>>>> I am in favor of adding .fts automatically to tablespace file names
>>>> that have no extension, and it seems that so is Ann.
> Actually, I'm in favor of adding .fts to all tablespace file names
> that don't already end in .fts. So tablespace.awh would become
> tablespace.awh.fts, and tablespace.MYI would become tablespace.MYI.fts.
> What I don't know is whether there are any supported operating systems
> that are strict about the number of extensions on a file. DOS did,
> and so did VAX/VMS, but those are both ancient history, saints be
> Vlad wrote:
>> The thing with the bug is that so far there is nothing falcon that would
>> prevent creating tablespace named t1.MYI or t1.par or whatever
>> server is using for different purposes.
> Maybe we could prevail on the server not to delete pre-existing files
> when creating tables and partitions. We don't delete pre-existing
> files when creating tablespaces ...
Maybe we should get sneaky and create all Falcon files without delete
permission, turning delete back on when we are good and ready to delete
files. Any reasonably privileged user could do the same thing, but he'd
have to think twice about what he was doing. But it will protect Falcon
users from the server unless the server picks up the same trick.
President, NimbusDB, Inc.