pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedScheme not dropping
2+ messages / 2 participants
[nested] [flat]
* Scheme not dropping
@ 2005-03-15 18:44 Graham Vickrage <graham@gpmd.co.uk>
0 siblings, 1 reply; 2+ messages in thread
From: Graham Vickrage @ 2005-03-15 18:44 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Scheme not dropping
@ 2005-03-15 19:52 Ragnar Hafstað <gnari@simnet.is>
parent: Graham Vickrage <graham@gpmd.co.uk>
0 siblings, 0 replies; 2+ messages in thread
From: Ragnar Hafstað @ 2005-03-15 19:52 UTC (permalink / raw)
To: Graham Vickrage <graham@gpmd.co.uk>; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-03-15 19:52 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-15 18:44 Scheme not dropping Graham Vickrage <graham@gpmd.co.uk>
2005-03-15 19:52 ` Ragnar Hafstað <gnari@simnet.is>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox