Thread: pgAdmin4 Maintenance gives Database does not exist
<div class="WordSection1"><p class="MsoNormal">Hello all,<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Thisis 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 doesnot exist’ error. For example, when I try to analyze database 815, I am getting the error : <span style="color:#333333">psql:FATAL: database ""815"" does not exist </span><p class="MsoNormal">Note the datebase name hastwo double quotes. Could this be a configuration issue?<p class="MsoNormal">Executine analyze in an sql window works fine.<p class="MsoNormal"> <p class="MsoNormal">Thanks,<p class="MsoNormal">Mark Watson</div>
I think - this should be inline with the case, you were working on #1603.
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
Hi Khushboo,Can you please take a look at this?
I think - this should be inline with the case, you were working on #1603.It should be fixed by using the '_label' variable.And, also create a separate case for this.
Mark Watson,Thank for the report.We will try to fix it in the next release.On Thu, Oct 20, 2016 at 6:23 PM, Mark Watson <mark.watson@jurisconcept.ca> wrote: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
On Thu, Oct 20, 2016 at 6:27 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote: Hi Khushboo,Can you please take a look at this?
I think - this should be inline with the case, you were working on #1603.It should be fixed by using the '_label' variable.And, also create a separate case for this.Yes, I have fixed this issue as you have mentioned but not yet committed.The same case already been reported : #1221
Mark Watson,Thank for the report.We will try to fix it in the next release.On Thu, Oct 20, 2016 at 6:23 PM, Mark Watson <mark.watson@jurisconcept.ca> wrote: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
<div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:16px"><divid="yui_3_16_0_ym19_1_1476971626120_10398"><b>I am not pgadmin4 support, but this looks tome like the problem is your naming convention.</b></div><div dir="ltr" id="yui_3_16_0_ym19_1_1476971626120_10379"><b id="yui_3_16_0_ym19_1_1476971626120_10798">PerPostgreSQL (and SQL) <font color="#cd232c">object names MUST start with a letter</font>.<aclass="edited-link-editor" href="https://www.postgresql.org/docs/9.6/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS" id="yui_3_16_0_ym19_1_1476971626120_10378"><br/></a></b></div><div dir="ltr" id="yui_3_16_0_ym19_1_1476971626120_10797"><bid="yui_3_16_0_ym19_1_1476971626120_10796"><a class="edited-link-editor" href="https://www.postgresql.org/docs/9.6/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS" id="yui_3_16_0_ym19_1_1476971626120_10378">https://www.postgresql.org/docs/9.6/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS</a></b></div><div id="yui_3_16_0_ym19_1_1476971626120_10397"><b><br/></b></div><div id="yui_3_16_0_ym19_1_1476971626120_10608"><b id="yui_3_16_0_ym19_1_1476971626120_10662">Sonames a database with a number (even if quoted), is a no no. <br /></b></div><divdir="ltr" id="yui_3_16_0_ym19_1_1476971626120_10646"><b id="yui_3_16_0_ym19_1_1476971626120_10795">Try renamingthe database to db815, and see if the problem still exists.<br /></b></div><div id="yui_3_16_0_ym19_1_1476971626120_10227"> </div><divclass="signature" id="yui_3_16_0_ym19_1_1476971626120_10181"><div class="qtdSeparateBR"id="yui_3_16_0_ym19_1_1476971626120_10247"><font size="4"><span style="font-weight:bold;font-family:arial;color:rgb(0,0, 255);">Melvin Davidson </span></font><br /><font size="3"> Cell720-320-0155 <br /></font><font id="yui_3_16_0_ym19_1_1476971626120_10187" size="3" style="font-weight:bold;"><span id="yui_3_16_0_ym19_1_1476971626120_10188"style="color:rgb(128, 0, 255);">I reserve the right to fantasize. Whether or notyou </span><br style="color:rgb(128, 0, 255);" /><span id="yui_3_16_0_ym19_1_1476971626120_10186" style="color:rgb(128,0, 255);">wish to share my fantasy is entirely up to you. </span><img class="img-overlay-selected" data-id="adf6315b-00b9-df87-55fb-368f10ad3c92"id="yui_3_16_0_ym19_1_1476971626120_10848" src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"style="color:rgb(128, 0, 255);" /><br /></font><font id="yui_3_16_0_ym19_1_1467319472979_3360"size="3" style="font-weight:bold;">www.youtube.com/unusedhero/videos<br /></font><fontid="yui_3_16_0_ym19_1_1476971626120_10824" size="3"><span id="yui_3_16_0_ym19_1_1476971626120_10825" style="font-weight:bold;font-family:courier;">FolkAlley - All Folk - 24 Hours a day </span><span id="yui_3_16_0_ym19_1_1476971626120_10823"style="font-weight:bold;font-family:courier;"><br />www.folkalley.com<br /></span></font><br/></div></div><div class="qtdSeparateBR"><br /><br /></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1476971626120_10253"style="display: block;"><div id="yui_3_16_0_ym19_1_1476971626120_10252" style="font-family:Courier New, courier, monaco, monospace, sans-serif; font-size: 16px;"><div id="yui_3_16_0_ym19_1_1476971626120_10251"style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande,sans-serif; font-size: 16px;"><div dir="ltr" id="yui_3_16_0_ym19_1_1476971626120_10250"><font face="Arial" id="yui_3_16_0_ym19_1_1476971626120_10249"size="2"><hr id="yui_3_16_0_ym19_1_1476971626120_10248" size="1" /><b><span style="font-weight:bold;">From:</span></b>Mark Watson <mark.watson@jurisconcept.ca><br /><b><span style="font-weight:bold;">To:</span></b> "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org> <br /><b><spanstyle="font-weight: bold;">Sent:</span></b> Thursday, October 20, 2016 8:53 AM<br /><b><span style="font-weight:bold;">Subject:</span></b> [pgadmin-support] pgAdmin4 Maintenance gives Database does not exist<br /></font></div><divclass="y_msg_container" id="yui_3_16_0_ym19_1_1476971626120_10254"><br /><div id="yiv4552170035"><style><!-- #yiv4552170035 _filtered #yiv4552170035 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}_filtered #yiv4552170035 {font-family:Tahoma;panose-1:211 6 4 3 5 4 4 2 4;} #yiv4552170035 #yiv4552170035 p.yiv4552170035MsoNormal, #yiv4552170035 li.yiv4552170035MsoNormal, #yiv4552170035 div.yiv4552170035MsoNormal{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri","sans-serif";} #yiv4552170035 a:link, #yiv4552170035 span.yiv4552170035MsoHyperlink{color:blue;text-decoration:underline;} #yiv4552170035 a:visited, #yiv4552170035 span.yiv4552170035MsoHyperlinkFollowed{color:purple;text-decoration:underline;} #yiv4552170035 p.yiv4552170035MsoAcetate, #yiv4552170035 li.yiv4552170035MsoAcetate, #yiv4552170035 div.yiv4552170035MsoAcetate{margin:0in;margin-bottom:.0001pt;font-size:8.0pt;font-family:"Tahoma","sans-serif";} #yiv4552170035 span.yiv4552170035EmailStyle17{font-family:"Calibri", "sans-serif";color:windowtext;} #yiv4552170035 span.yiv4552170035TextedebullesCar{font-family:"Tahoma", "sans-serif";} #yiv4552170035 .yiv4552170035MsoChpDefault{font-family:"Calibri", "sans-serif";}_filtered #yiv4552170035 {margin:1.0in 1.0in1.0in 1.0in;} #yiv4552170035 div.yiv4552170035WordSection1{} #yiv4552170035 _filtered #yiv4552170035 {} #yiv4552170035 ol{margin-bottom:0in;} #yiv4552170035 ul{margin-bottom:0in;} --></style><div id="yui_3_16_0_ym19_1_1476971626120_10257"><div class="yiv4552170035WordSection1" id="yui_3_16_0_ym19_1_1476971626120_10256"><divclass="yiv4552170035MsoNormal" id="yui_3_16_0_ym19_1_1476971626120_10255">Helloall,</div><div class="yiv4552170035MsoNormal" id="yui_3_16_0_ym19_1_1476971626120_10258"style="">This is in no way urgent, and concerns pgAdmin4 on windows 10, with postgres9.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 : <span id="yui_3_16_0_ym19_1_1476971626120_10801"style="color:#333333;">psql: FATAL: database ""815"" does not exist </span></div><divclass="yiv4552170035MsoNormal" id="yui_3_16_0_ym19_1_1476971626120_10259">Note the datebase name has twodouble quotes. Could this be a configuration issue?</div><div class="yiv4552170035MsoNormal" id="yui_3_16_0_ym19_1_1476971626120_10850">Executineanalyze in an sql window works fine. </div><div class="yiv4552170035MsoNormal"id="yui_3_16_0_ym19_1_1476971626120_10260"> </div><div class="yiv4552170035MsoNormal">Thanks,</div><divclass="yiv4552170035MsoNormal">Mark Watson</div></div></div></div><br /><br/></div></div></div></div></div>
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
… 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.
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
Attachment
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
![](http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif)
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
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
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.](/media/maillist_attaches/pgadmin-support/2016/10/20/1427440611.412840.1476974090907@mail.yahoo.com/%7EWRD000.jpg)
www.youtube.com/unusedhero/videos
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
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
Attachment
Since postgresql officially allows mixed case names for objects, applications have to support it.
Michal
On 20.10.2016 16:34, Melvin Davidson wrote:
Mark,Please DO NOT use CamelCase names (or UPPERCASE) in PostgreSQL. By default, PostgreSQL will convertall 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 nottranslate 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- MarkDe : 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 existI 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
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.comFrom: 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 existHello 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 existNote the datebase name has two double quotes. Could this be a configuration issue?Executine analyze in an sql window works fine.Thanks,Mark Watson