Tom Lane wrote:
Gregory Stark <[EMAIL PROTECTED]> writes:
"Michael Fuhr" <[EMAIL PROTECTED]> 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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
