Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DDCE12E3374 for ; Wed, 6 Feb 2008 18:33:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 69911-08 for ; Wed, 6 Feb 2008 18:33:41 -0400 (AST) Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192]) by postgresql.org (Postfix) with ESMTP id 78B382E336B for ; Wed, 6 Feb 2008 18:33:46 -0400 (AST) Received: from [192.168.10.1] (ASte-Genev-Bois-153-1-10-117.w83-112.abo.wanadoo.fr [83.112.72.117]) by sd-2317.dedibox.fr (Postfix) with ESMTP id AC063A44A; Wed, 6 Feb 2008 23:33:42 +0100 (CET) Message-ID: <47AA35C5.6080600@lelarge.info> Date: Wed, 06 Feb 2008 23:33:41 +0100 From: Guillaume Lelarge User-Agent: Thunderbird 2.0.0.9 (X11/20071112) MIME-Version: 1.0 To: Nuwan Liyanage CC: pgsql-admin@postgresql.org Subject: Re: rename database References: <465222.91055.qm@web46015.mail.sp1.yahoo.com> In-Reply-To: <465222.91055.qm@web46015.mail.sp1.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/68 X-Sequence-Number: 28142 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