Re: Correct behaviour of "DROP DATABASE"

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