Re: pgAdmin4 Maintenance gives Database does not exist

Mark,

Please DO NOT use CamelCase names (or UPPERCASE) in PostgreSQL. By default, PostgreSQL will convert

all names to lowercase (unless quoted). However, quoting object names is never a good idea and CamelCase

(or UPPERCASE) names are not necessary. They are a hold over from application programming, but do not

translate well to databases.

Melvin Davidson
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: Melvin Davidson <melvin6925@yahoo.com>; "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
Sent: Thursday, October 20, 2016 10:27 AM
Subject: RE: [pgadmin-support] pgAdmin4 Maintenance gives Database does not exist

#yiv6783574282 #yiv6783574282 --_filtered #yiv6783574282 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;}_filtered #yiv6783574282 {font-family:Courier;panose-1:2 7 4 9 2 2 5 2 4 4;}_filtered #yiv6783574282 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}_filtered #yiv6783574282 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;}_filtered #yiv6783574282 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}_filtered #yiv6783574282 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} #yiv6783574282 #yiv6783574282 p.yiv6783574282MsoNormal, #yiv6783574282 li.yiv6783574282MsoNormal, #yiv6783574282 div.yiv6783574282MsoNormal{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;} #yiv6783574282 a:link, #yiv6783574282 span.yiv6783574282MsoHyperlink{color:blue;text-decoration:underline;} #yiv6783574282 a:visited, #yiv6783574282 span.yiv6783574282MsoHyperlinkFollowed{color:purple;text-decoration:underline;} #yiv6783574282 p.yiv6783574282MsoAcetate, #yiv6783574282 li.yiv6783574282MsoAcetate, #yiv6783574282 div.yiv6783574282MsoAcetate{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;} #yiv6783574282 p.yiv6783574282MsoListParagraph, #yiv6783574282 li.yiv6783574282MsoListParagraph, #yiv6783574282 div.yiv6783574282MsoListParagraph{margin-top:0in;margin-right:0in;margin-bottom:0in;margin-left:.5in;margin-bottom:.0001pt;font-size:12.0pt;} #yiv6783574282 p.yiv6783574282msoacetate, #yiv6783574282 li.yiv6783574282msoacetate, #yiv6783574282 div.yiv6783574282msoacetate{margin-right:0in;margin-left:0in;font-size:12.0pt;} #yiv6783574282 p.yiv6783574282msonormal, #yiv6783574282 li.yiv6783574282msonormal, #yiv6783574282 div.yiv6783574282msonormal{margin-right:0in;margin-left:0in;font-size:12.0pt;} #yiv6783574282 p.yiv6783574282msochpdefault, #yiv6783574282 li.yiv6783574282msochpdefault, #yiv6783574282 div.yiv6783574282msochpdefault{margin-right:0in;margin-left:0in;font-size:12.0pt;} #yiv6783574282 span.yiv6783574282msohyperlink{} #yiv6783574282 span.yiv6783574282msohyperlinkfollowed{} #yiv6783574282 span.yiv6783574282emailstyle17{} #yiv6783574282 span.yiv6783574282textedebullescar{} #yiv6783574282 p.yiv6783574282msonormal1, #yiv6783574282 li.yiv6783574282msonormal1, #yiv6783574282 div.yiv6783574282msonormal1{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;} #yiv6783574282 span.yiv6783574282msohyperlink1{color:blue;text-decoration:underline;} #yiv6783574282 span.yiv6783574282msohyperlinkfollowed1{color:purple;text-decoration:underline;} #yiv6783574282 p.yiv6783574282msoacetate1, #yiv6783574282 li.yiv6783574282msoacetate1, #yiv6783574282 div.yiv6783574282msoacetate1{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;} #yiv6783574282 span.yiv6783574282emailstyle171{color:windowtext;} #yiv6783574282 span.yiv6783574282textedebullescar1{} #yiv6783574282 p.yiv6783574282msochpdefault1, #yiv6783574282 li.yiv6783574282msochpdefault1, #yiv6783574282 div.yiv6783574282msochpdefault1{margin-right:0in;margin-left:0in;font-size:12.0pt;} #yiv6783574282 span.yiv6783574282EmailStyle31{color:#1F497D;} #yiv6783574282 span.yiv6783574282TextedebullesCar{} #yiv6783574282 .yiv6783574282MsoChpDefault{font-size:10.0pt;}_filtered #yiv6783574282 {margin:1.0in 1.0in 1.0in 1.0in;} #yiv6783574282 div.yiv6783574282WordSection1{} #yiv6783574282 _filtered #yiv6783574282 {}_filtered #yiv6783574282 {}_filtered #yiv6783574282 {}_filtered #yiv6783574282 {}_filtered #yiv6783574282 {font-family:Wingdings;}_filtered #yiv6783574282 {font-family:Symbol;}_filtered #yiv6783574282 {}_filtered #yiv6783574282 {font-family:Wingdings;}_filtered #yiv6783574282 {font-family:Symbol;}_filtered #yiv6783574282 {}_filtered #yiv6783574282 {font-family:Wingdings;} #yiv6783574282 ol{margin-bottom:0in;} #yiv6783574282 ul{margin-bottom:0in;} #yiv6783574282

… But if the name of the database contains uppercase characters, the same problem arises :

 

psql: FATAL: database ""Dj"" does not exist

-          Mark

 

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.

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

 

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