Postgres Pro
Downloads
Home   >   mailing lists

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 1427440611.412840.1476974090907@mail.yahoo.com
Whole thread Raw
In response to Re: pgAdmin4 Maintenance gives Database does not exist  (Mark Watson <mark.watson@jurisconcept.ca>)
Responses Re: pgAdmin4 Maintenance gives Database does not exist
List pgadmin-support
Tree view
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.
 
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. Image supprimée par l'expéditeur.
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
 


Attachment

pgadmin-support by date:

Previous
From: Mark Watson
Date:
Subject: Re: pgAdmin4 Maintenance gives Database does not exist
Next
From: Michael Higgins
Date:
Subject: PgAdmin4 Bug report - Zoomed too far out