Re: Scheme not dropping

From: Ragnar Hafstað <gnari(at)simnet(dot)is>
To: Graham Vickrage <graham(at)gpmd(dot)co(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Scheme not dropping
Date: 2005-03-15 19:52:15
Message-ID: 1110916335.26976.63.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Hermann Draeger 2005-03-15 22:15:24 tablename as function parameter
Previous Message Graham Vickrage 2005-03-15 18:44:10 Scheme not dropping