X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6BFF956711 for ; Tue, 15 Mar 2005 19:52:00 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91482-10 for ; Tue, 15 Mar 2005 19:51:56 +0000 (GMT) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by svr1.postgresql.org (Postfix) with ESMTP id 56081568B9 for ; Tue, 15 Mar 2005 19:51:54 +0000 (GMT) Received: from gnari ([157.157.159.208] [157.157.159.208]) by quasar.skima.is with ESMTP; Tue, 15 Mar 2005 19:51:55 Z Subject: Re: Scheme not dropping From: Ragnar =?ISO-8859-1?Q?Hafsta=F0?= To: Graham Vickrage Cc: pgsql-sql@postgresql.org In-Reply-To: <012301c5298e$fa60a620$0867a8c0@gvickrage> References: <012301c5298e$fa60a620$0867a8c0@gvickrage> Content-Type: text/plain Date: Tue, 15 Mar 2005 19:52:15 +0000 Message-Id: <1110916335.26976.63.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/225 X-Sequence-Number: 20704 On Tue, 2005-03-15 at 18:44 +0000, Graham Vickrage wrote: > I am dropping a database with an additional scheme other than public on > version 7.3.2. > > When I come to recreate the database with the same scheme it gives me > the error: > > ERROR: namespace "xxx" already exists does the scheme exist in template1 (or the database you are using as template when you create database) ? gnari