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