Rightly as Guillaume said, tampering with a system table isn't a very good idea.
This is what he suggested: 1. Lets say you are connected to Database A 2. Reconnect to Database B on the server (this database B could be any database other than A on the server) 3. Rename database A to C 4. Reconnect to C Without step 2, step 3 would always spew the error about unable to rename the 'current database'. *Robins* ---------- Forwarded message ---------- From: Mag Gam <[EMAIL PROTECTED]> Date: Feb 7, 2008 9:22 AM Subject: Re: [ADMIN] rename database To: Guillaume Lelarge <[EMAIL PROTECTED]> Cc: Nuwan Liyanage <[EMAIL PROTECTED]>, pgsql-admin@postgresql.org what's the right way to rename a database then? On Feb 6, 2008 5:33 PM, Guillaume Lelarge <[EMAIL PROTECTED]> wrote: > Nuwan Liyanage wrote: > > Ok I think I got it. I just went ahead and updated the pg_database table > > and it works.. > > > > A better way is to connect to another database (template1 for exemple, > but you would better use another one) and fire your statement there. > > Updating system table can be dangerous. > > > -- > Guillaume. > http://www.postgresqlfr.org > http://dalibo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >
