Re: DROP DATABASE always seeing database in use

Tom Lane wrote:
> 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.

Yes, that should be easy enough.

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

Yeah, the prepared xact might have modified shared catalogs, for example.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com