Re: Dropped database still shows in the database list.

[girish R G peetle <giri.anamika0@xxxxxxxxx>]

Thanks a lot, got it.

Thanks

Girish

On Fri, May 22, 2015 at 1:36 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Thursday, May 21, 2015, girish R G peetle <giri.anamika0@xxxxxxxxx> wrote:

Hi,

Dropped database 'RestoreDB' is still being listed in pg_database. 

Any idea why this behavior is seen ? Also I don't see any open connections to this database. 

Try removing your where clause on the select,

"RestoreDB" and RestoreDB are two different databases.  The later is case-folded to be equivalent to "restoredb".

The double quotes I'm using are significant.

David J.