Thread: pgAdmin4 Maintenance gives Database does not exist

pgAdmin4 Maintenance gives Database does not exist

From

Mark Watson

Date:

20 October 2016, 12:53:33

<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

From

Ashesh Vashi

Date:

20 October 2016, 12:57:57

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

From

Khushboo Vashi

Date:

20 October 2016, 13:01:14

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

From

Ashesh Vashi

Date:

20 October 2016, 13:03:16

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

From

Melvin Davidson

Date:

20 October 2016, 14:12:06

<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

From

Mark Watson

Date:

20 October 2016, 14:18:58

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

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

From

Mark Watson

Date:

20 October 2016, 14:27:23

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

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

- Mark

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

Hello all,

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

%7EWRD000.jpg

Re: pgAdmin4 Maintenance gives Database does not exist

From

Melvin Davidson

Date:

20 October 2016, 14:37:51

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
  

Attachment

%7EWRD000.jpg

Re: pgAdmin4 Maintenance gives Database does not exist

From

Michal Kozusznik

Date:

21 October 2016, 08:25:41

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

Attachment

kozusznik_michal.vcf