Обсуждение: pgAdmin4 Maintenance gives Database does not exist

Поиск
Список
Период
Сортировка

pgAdmin4 Maintenance gives Database does not exist

От
Mark Watson
Дата:
<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>

Re: pgAdmin4 Maintenance gives Database does not exist

От
Ashesh Vashi
Дата:
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.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi


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


Re: pgAdmin4 Maintenance gives Database does not exist

От
Khushboo Vashi
Дата:


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.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi


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



Re: pgAdmin4 Maintenance gives Database does not exist

От
Ashesh Vashi
Дата:


On Thu, Oct 20, 2016 at 6:31 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:


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
Ok.
Thanks for the confirmation.
And, I just wanted to make sure, we do not miss this one.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi

 
Mark Watson,

Thank for the report.
We will try to fix it in the next release.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi


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




Re: pgAdmin4 Maintenance gives Database does not exist

От
Melvin Davidson
Дата:
<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>

Re: pgAdmin4 Maintenance gives Database does not exist

От
Mark Watson
Дата:

 

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

 

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

 

Re: pgAdmin4 Maintenance gives Database does not exist

От
Mark Watson
Дата:

… 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

 

Вложения

Re: pgAdmin4 Maintenance gives Database does not exist

От
Melvin Davidson
Дата:
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
 


Вложения

Re: pgAdmin4 Maintenance gives Database does not exist

От
Michal Kozusznik
Дата:
You are right regarding best practices but I cannot agree with your "do not translate well"
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 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
 






			
		

		
			
Вложения