I have to create db name starting with number; when I start duplicate an existing db and give number then it shows invalid name. Is there any kind of restriction setup for Postgres; how can I override/change that restriction?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Бухгалтерия
- Склад
- PoS
- Проекты
- MRP
Этот вопрос был отмечен
1
Ответить
8750
Представления
In PostgreSQL, if you use number in front or capital letter anywhere in the object name, you need to surround the name with double quote: "70_this_is_my_database"
Hi John, I tried both double & single quotes but OpenERP is saying "Invalid database name".
Are you trying to duplicate from the Manage Database? Sorry I did not catch that earlier, but from that menu you can only use names that starts not with numbers and does not contain capital letters. You can later rename it using PostgreSQL's tools.
I had tried by creating new as well as duplicating. Both times I was getting error of invalid database name. I will try by replacing it directly in PostgreSQL.
Yes for both creating and duplicating database from Manage Database you need to specify name that does not start with number and does not contain capital letters.
Не оставайтесь в стороне – присоединяйтесь к обсуждению!
Создайте аккаунт сегодня, чтобы получить доступ к эксклюзивным функциям и стать частью нашего замечательного сообщества!
Регистрация| Похожие посты | Ответы | Просмотры | Активность | |
|---|---|---|---|---|
|
1
июл. 23
|
6645 | ||
|
Change the database name
Решено
|
|
2
июн. 23
|
16719 | |
|
1
мар. 15
|
6273 | ||
|
1
июл. 25
|
4403 | ||
|
0
июн. 24
|
2411 |
