Re: Incorrect "ERROR: database "xxx" is being accessed by other users"

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"...
Database restart does not reset the prepared transaction...

On 3/13/07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> "Dmitry Koterov" <dmitry(at)koterov(dot)ru> writes:
> > I have a database which I cannot delete (the same for rename):
> > ERROR: database "xxx" is being accessed by other users
> > But it is NOT accessed by anybody, because:
>
> Have you checked for prepared transactions in that DB? See
> pg_prepared_xacts view (I've been burnt by that myself...)
>
> regards, tom lane
>