Deleted database still shows in database list in PostgreSQL SQLmanager

Question

Using PostgreSQL 9.4.12, I created a new database called new_db and before adding any table or any other object to it and probably before registering it (I don't remember if I've registered or not), I dropped it. Now, it still shows in database list in SQLmanager:

and when I attempt to drop it via following query:

drop database new_db;

it says:

database doesn't exist

But when I open 'database registration manager', it lists 'new_db' and shows the register check box as marked:

and when I try to remove the mark and apply the changes it displays an error that isn't relevant to the 'new_db' database.

Following query also results 0 rows:

select oid, * from pg_database where datname like
   'new_db';

How can I remove the database from the list in SQLmanager?

did you try right click on new_db and "unregister database"?.. — Vao Tsun, Dec 06 '17 at 08:25
After restarting the machine I right clicked on the DB, unregistered it, and it worked. Thank you — Ms workaholic, Dec 06 '17 at 16:13

score 1 · Accepted Answer · answered Dec 06 '17 at 16:15

1

SQL Manager creates new_db (asdefault anme) on first connection. After that it registers it. If you just drop database and don't unregister it the "alias" remains. You have to right click on new_db and "unregister database"

answered Dec 06 '17 at 16:15

Vao Tsun

47,234
13
100
132

Deleted database still shows in database list in PostgreSQL SQLmanager

1 Answers1