Re: [GENERAL] Mysterious empty database name?

2010-05-25 Thread Azlin Rahim
Thanks Tom, Alvaro. It was indeed caused by the carriage return. I've renamed the weird db and the problem is resolved. On Wed, May 26, 2010 at 7:14 AM, Tom Lane wrote: > Azlin Rahim writes: >> I tried to do another SELECT on pg_database with the OID and here's >> wha

Re: [GENERAL] Mysterious empty database name?

2010-05-25 Thread Azlin Rahim
499 | 1663 | | (9 rows) On Wed, May 26, 2010 at 6:40 AM, Tom Lane wrote: > > Azlin Rahim writes: > > In our database list, there is one 'mysterious' database with a blank name. > > We don't know how it got there. > > Your mail client has done yo

[GENERAL] Mysterious empty database name?

2010-05-25 Thread Azlin Rahim
In our database list, there is one 'mysterious' database with a blank name. We don't know how it got there. Below is the output of pg_database. Does anyone have any idea why this is happening? Any way to remove the 'mysterious' database safely. datname | datdba | encoding | dat