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 7C5EE56893 for ; Tue, 15 Mar 2005 18:44:22 +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 44087-01 for ; Tue, 15 Mar 2005 18:44:18 +0000 (GMT) Received: from mailserver.gpmd.co.uk (unknown [217.8.241.55]) by svr1.postgresql.org (Postfix) with ESMTP id 09F735688F for ; Tue, 15 Mar 2005 18:44:14 +0000 (GMT) Received: (qmail 10777 invoked by uid 107); 15 Mar 2005 18:44:12 -0000 Received: from host-84-9-13-245.bulldogdsl.com (HELO gvickrage) (graham@gpmd.net@84.9.13.245) by reserved.versado.co.uk with SMTP; 15 Mar 2005 18:44:12 -0000 From: "Graham Vickrage" To: Subject: Scheme not dropping Date: Tue, 15 Mar 2005 18:44:10 -0000 Message-ID: <012301c5298e$fa60a620$0867a8c0@gvickrage> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/224 X-Sequence-Number: 20703 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 Is this temp table issue, if so how do I get round it? Many thanks in advance. Graham