Re: pgAdmin4 Maintenance gives Database does not exist

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: pgAdmin4 Maintenance gives Database does not exist
Дата
Msg-id 1427440611.412840.1476974090907@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: pgAdmin4 Maintenance gives Database does not exist  (Mark Watson <mark.watson@jurisconcept.ca>)
Ответы Re: pgAdmin4 Maintenance gives Database does not exist
Список pgadmin-support
Дерево обсуждения
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
 


Вложения

В списке pgadmin-support по дате отправления:

Предыдущее
От: Mark Watson
Дата:
Сообщение: Re: pgAdmin4 Maintenance gives Database does not exist
Следующее
От: Michael Higgins
Дата:
Сообщение: PgAdmin4 Bug report - Zoomed too far out