Re: pgAdmin4 Maintenance gives Database does not exist - Mailing list pgadmin-support

From Melvin Davidson
Subject Re: pgAdmin4 Maintenance gives Database does not exist
Date
Msg-id 1802527597.401311.1476972554883@mail.yahoo.com
Whole thread Raw
In response to pgAdmin4 Maintenance gives Database does not exist  (Mark Watson <mark.watson@jurisconcept.ca>)
Responses Re: pgAdmin4 Maintenance gives Database does not exist
Re: pgAdmin4 Maintenance gives Database does not exist
List pgadmin-support
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.

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
    Cell 720-320-0155
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com




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


pgadmin-support by date:

Previous
From: Ricardo Ramírez
Date:
Subject: ...
Next
From: Mark Watson
Date:
Subject: Re: pgAdmin4 Maintenance gives Database does not exist