Re: Can't rename an existnig DB because it doesn't exist??? - Mailing list pgsql-general

From Tom Lane
Subject Re: Can't rename an existnig DB because it doesn't exist???
Date
Msg-id 27308.1205434948@sss.pgh.pa.us
Whole thread Raw
In response to Re: Can't rename an existnig DB because it doesn't exist???  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
"Gauthier, Dave" <dave.gauthier@intel.com> writes:
> Can't rename a db, complains that it doesn't exist.  Yet psql -l
> shows that it does and I can connect to it ???
>
> mmdcc228_SETUP(120)% psql stdb2 -c "alter database stdb rename to
> stdb_tmp"
>
> ERROR:  database "stdb" does not exist

Hmm, I wonder if this could be a corrupt-index problem.  If you
try "select * from pg_database where datname = 'stdb'", do you
get a row? Does "REINDEX pg_database" help?

            regards, tom lane

pgsql-general by date:

Previous
From: rrahul
Date:
Subject: Re: postgre vs MySQL
Next
From: Steve Crawford
Date:
Subject: Re: postgre vs MySQL