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

<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>