Re: pgAdmin4 Maintenance gives Database does not exist
От | Mark Watson |
---|---|
Тема | Re: pgAdmin4 Maintenance gives Database does not exist |
Дата | |
Msg-id | 02F1BBB48ABD3245A3BC519B57CFC8CAF723ED8A@Exchange.JurisConcept.local обсуждение исходный текст |
Ответ на | Re: pgAdmin4 Maintenance gives Database does not exist (Melvin Davidson <melvin6925@yahoo.com>) |
Список | pgadmin-support |
De : Melvin Davidson [mailto:melvin6925@yahoo.com]
Envoyé : Thursday, October 20, 2016 10:09 AM
À : Mark Watson; pgadmin-support@postgresql.org
Objet : Re: [pgadmin-support] pgAdmin4 Maintenance gives Database does not exist
I am not pgadmin4 support, but this looks to me like the problem is your naming convention.
So names a database with a number (even if quoted), is a no no.
Try renaming the database to db815, and see if the problem still exists.
Melvin Davidson
From: Mark Watson <mark.watson@jurisconcept.ca>
To: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
Sent: Thursday, October 20, 2016 8:53 AM
Subject: [pgadmin-support] pgAdmin4 Maintenance gives Database does not exist
Hello all,
This is in no way urgent, and concerns pgAdmin4 on windows 10, with postgres 9.6. When I right-click on the database, choose maintence, and run analyze, I am getting a ‘database does not exist’ error. For example, when I try to analyze database 815, I am getting the error : psql: FATAL: database ""815"" does not exist
Note the datebase name has two double quotes. Could this be a configuration issue?
Executine analyze in an sql window works fine.
Thanks,
Mark Watson
Thank-you Melvin,
Renaming the database to start with a letter solved the problem.
- Mark
В списке pgadmin-support по дате отправления: