Thanks a lot! All works!
So - I propose to change error message from
ERROR: database "xxx" is being accessed by other users
to
ERROR: database "xxx" is being accessed by other users or there are prepared transactions exist (please use "SELECT * FROM pg_prepared_xacts" and "ROLLBACK PREPARED ..." to fix this)
in a new PG version. Is it possible?
On 3/13/07, Michael Fuhr <mike@fuhr.org> wrote: On Tue, Mar 13, 2007 at 11:41:46AM +0300, Dmitry Koterov wrote:
> Yes, I have one!
> How to remove it now? I tried DEALLOCATE for gid returned by
>
> select * from pg_prepared_xacts;
>
> but it says "prepared statement does not exist"...
DEALLOCATE is for prepared *statements*; you have a prepared
*transaction*. Connect to the database you're trying to drop and
use ROLLBACK PREPARED or COMMIT PREPARED, then disconnect from that
database and try dropping it again.
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
