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 <[EMAIL PROTECTED]> 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
