Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 003912E343E for ; Wed, 6 Feb 2008 16:35:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 17264-03 for ; Wed, 6 Feb 2008 16:35:44 -0400 (AST) Received: from n4b.bullet.ukl.yahoo.com (n4b.bullet.ukl.yahoo.com [217.146.183.158]) by postgresql.org (Postfix) with SMTP id B4E5C2E3380 for ; Wed, 6 Feb 2008 16:35:43 -0400 (AST) Received: from [217.12.4.215] by n4.bullet.ukl.yahoo.com with NNFMP; 06 Feb 2008 20:35:42 -0000 Received: from [216.252.122.218] by t2.bullet.ukl.yahoo.com with NNFMP; 06 Feb 2008 20:35:42 -0000 Received: from [69.147.65.170] by t3.bullet.sp1.yahoo.com with NNFMP; 06 Feb 2008 20:35:41 -0000 Received: from [127.0.0.1] by omp505.mail.sp1.yahoo.com with NNFMP; 06 Feb 2008 20:35:41 -0000 X-Yahoo-Newman-Property: ymail-5 X-Yahoo-Newman-Id: 704046.92418.bm@omp505.mail.sp1.yahoo.com Received: (qmail 91606 invoked by uid 60001); 6 Feb 2008 20:35:41 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=MLsS/WzvuPcn/QSOdhhppN30hwxC5qFVqmjOHnVbJuZdKXUFWYgVBrFFwLzr3Zfb/GimWm6tHOxLWYQEspmXRe/hYY89z5+/3Iilfj1Dvdjoe4VGCh86nH7HOotJh1dKJNIeni1NT6PMSuMPdHnMqE1SxFmQmqJrfliDMiH8eGw=; X-YMail-OSG: 4rRY0EgVM1lsS5NlHaltrRUtkvkwwOrJnQxZXlB2QoKZrSLg1NFaRCFN_qt3UrkBbL1KkTYvDqavP7miRVhV0pgAXg-- Received: from [128.8.215.134] by web46015.mail.sp1.yahoo.com via HTTP; Wed, 06 Feb 2008 12:35:41 PST Date: Wed, 6 Feb 2008 12:35:41 -0800 (PST) From: Nuwan Liyanage Subject: Re: rename database To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-220629417-1202330141=:91055" Content-Transfer-Encoding: 8bit Message-ID: <465222.91055.qm@web46015.mail.sp1.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200802/66 X-Sequence-Number: 28140 --0-220629417-1202330141=:91055 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Ok I think I got it. I just went ahead and updated the pg_database table and it works.. Nuwan Liyanage wrote: Hi, I am trying to rename my database; I used the following command, Alter database postgres rename to post_dev; but I get a error saying that the "current database may not be renamed" I look at the documentation, and it says that I need to connect to a different database in order do that? can someone please help me how to do that.. Thanks alnuwan --------------------------------- Never miss a thing. Make Yahoo your homepage. --------------------------------- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. --0-220629417-1202330141=:91055 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Ok I think I got it. I just went ahead and updated the pg_database table and it works..


Nuwan Liyanage <alnuwan2@yahoo.com> wrote:
Hi,
       I am trying to rename my database; I used the following command,
Alter database postgres rename to post_dev;
but I get a error saying that the "current database may not be renamed"
I look at the documentation, and it says that I need to connect to a different database in order do that?
can someone please help me how to do that..
Thanks
alnuwan

Never miss a thing. Make Yahoo your homepage.


Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. --0-220629417-1202330141=:91055--