Re: directory name equal database name
От | Tom Lane |
---|---|
Тема | Re: directory name equal database name |
Дата | |
Msg-id | 7029.1580833215@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | directory name equal database name (squid ward <squidw@mail.ru>) |
Ответы |
Re[2]: directory name equal database name
|
Список | pgsql-interfaces |
=?UTF-8?B?c3F1aWQgd2FyZA==?= <squidw@mail.ru> writes: > Question is why directory name not equal as database name? Because (1) it doesn't work for database names that aren't legal as filenames (according to the none-too-well-standardized rules of your particular filesystem); (2) SQL requires us to treat "FOO" and "foo" as distinct names, but the filesystem might not; (3) renaming a database is dangerous, as there's no way to make the directory rename action atomic with commit of the system catalog updates; (4) renaming a database causes problems for concurrent sessions that might be in the middle of opening files in that database. And probably a few other reasons I don't recall off the top of my head. > Can i change it? No. regards, tom lane
В списке pgsql-interfaces по дате отправления: