From: | Melvin Davidson <melvin6925(at)yahoo(dot)com> |
---|---|
To: | Mark Watson <mark(dot)watson(at)jurisconcept(dot)ca>, "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: pgAdmin4 Maintenance gives Database does not exist |
Date: | 2016-10-20 14:09:14 |
Message-ID: | 1802527597.401311.1476972554883@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(dot)watson(at)jurisconcept(dot)ca>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Sent: Thursday, October 20, 2016 8:53 AM
Subject: [pgadmin-support] pgAdmin4 Maintenance gives Database does not exist
<!--#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:2 11 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.0in 1.0in 1.0in;}#yiv4552170035 div.yiv4552170035WordSection1 {}#yiv4552170035 _filtered #yiv4552170035 {}#yiv4552170035 ol {margin-bottom:0in;}#yiv4552170035 ul {margin-bottom:0in;}-->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
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Watson | 2016-10-20 14:18:46 | Re: pgAdmin4 Maintenance gives Database does not exist |
Previous Message | Ricardo Ramírez | 2016-10-20 13:08:58 |