Thread: Scheme not dropping

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

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