Re: DROP DATABASE always seeing database in use

Gregory Stark <stark@enterprisedb.com> writes:
> "Michael Fuhr" <mike@fuhr.org> writes:
>> Are any prepared transactions still open?

> Uh, yes, I did notice that but didn't put two and two together. That does make
> sense now that you mention it.

I've been bit by that too, and so have other people.  Maybe it'd be
worth the trouble to improve the message so that it explicitly tells you
when there are prepared transactions blocking the DROP.

Another possibility is to let the DROP automatically roll back the
conflicting prepared xacts, but that seems a bit dangerous.
        regards, tom lane