De : Melvin Davidson [mailto:melvin6...@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. Per PostgreSQL (and SQL) object names MUST start with a letter. <https://www.postgresql.org/docs/9.6/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS> https://www.postgresql.org/docs/9.6/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS 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.wat...@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
