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 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 <[email protected]>
To: Melvin Davidson <[email protected]>; "[email protected]"
<[email protected]>
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:[email protected]]
Envoyé : Thursday, October 20, 2016 10:09 AM
À : Mark Watson; [email protected]
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 <[email protected]>
To: "[email protected]" <[email protected]>
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
--
Sent via pgadmin-support mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
