Re: pgAdmin4 Maintenance gives Database does not exist

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

In response to

Responses

Browse pgadmin-support by date

  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