Re: Correct behaviour of "DROP DATABASE" - Mailing list pgsql-general

From Tom Lane
Subject Re: Correct behaviour of "DROP DATABASE"
Date
Msg-id 27607.983241717@sss.pgh.pa.us
Whole thread Raw
In response to Correct behaviour of "DROP DATABASE"  (Ben Leslie <benno@sesgroup.net>)
Responses Re: Correct behaviour of "DROP DATABASE"
List pgsql-general
Ben Leslie <benno@sesgroup.net> writes:
> I was wondering what the expected behaviour of "DROP DATABASE" was.

> Basically the problem i have is that when I drop a database it seems
> to drop only some of the associated tables.

That is *real* hard to believe, considering that the entire database
including system catalogs is physically removed (rm -rf no less) by
DROP DATABASE.  There is nothing left in which table names could
appear, mixed-case or otherwise, much less the tables themselves.

What PG version are you running, and exactly what are you doing that
gives you unexpected results?

            regards, tom lane

pgsql-general by date:

Previous
From: GH
Date:
Subject: Re: Correct behaviour of "DROP DATABASE"
Next
From: Chris
Date:
Subject: Re: difficulty building PostgreSQL with PHP4?