Re: Can't rename an existnig DB because it doesn't exist???

You might want to keep this one on the list.  I'm out of my league
with this one I think

On Wed, Mar 12, 2008 at 11:24 AM, Gauthier, Dave
<dave.gauthier@intel.com> wrote:
> stdb2=#  select '|'||datname||'|' from pg_database ;
>     ?column?
>  ----------------
>   |postgres|
>   |template1|
>   |template0|
>   |cells_dev|
>   |stdb2|
>   |stdb|
>   |stdb_standby|
>   |cells|
>  (8 rows)
>
>
>
>
>
>  -----Original Message-----
>  From: Scott Marlowe [mailto:scott.marlowe@gmail.com]
>  Sent: Wednesday, March 12, 2008 1:22 PM
>  To: Gauthier, Dave
>  Cc: pgsql-general@postgresql.org
>  Subject: Re: [GENERAL] Can't rename an existnig DB because it doesn't
>  exist???
>
>  On Wed, Mar 12, 2008 at 10:03 AM, Gauthier, Dave
>  <dave.gauthier@intel.com> wrote:
>  >
>  >
>  > V8.2.0 on Linux
>
>  Look into updating, there were some serious bugs fixed between 8.2.0
>  and 8.2.6  It's a pretty simple thing, since you don't need to dump /
>  reload for it.
>
>  >
>  > 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
>  >
>  > mmdcc228_SETUP(121)% psql -l
>  >
>  >          List of databases
>  >
>  >      Name     |  Owner   | Encoding
>  >
>  > --------------+----------+----------
>  >  stdb         | dfgauthi | UTF8
>  >
>  >  stdb2        | dfgauthi | UTF8
>  >
>  >  stdb_standby | dfgauthi | UTF8
>
>  Very strange.  maybe the name has a space in it?
>
>  Try running this query:
>   select '|'||datname||'|' from pg_database ;
>  and see if you have a space or something in there.  can you run the
>  alter database rename from the command line and just not from psql?
>