Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres 8.2.9 can't drop database in single user mode - Mailing list pgsql-admin

From Tom Lane
Subject Re: postgres 8.2.9 can't drop database in single user mode
Date
Msg-id 20202.1240372406@sss.pgh.pa.us
Whole thread Raw
In response to postgres 8.2.9 can't drop database in single user mode  ("Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>)
Responses Re: postgres 8.2.9 can't drop database in single user mode  ("Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>)
List pgsql-admin
Tree view 
"Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov> writes:
> i'm getting the following error.....  any ideas why this would be in
> single user mode??

Maybe you've got some prepared transactions laying about?
Check pg_prepared_xacts ...

            regards, tom lane

pgsql-admin by date:

Previous
From: "Maria L. Wilson"
Date:
Subject: Re: postgres 8.2.9 can't drop database in single user mode
Next
From: "Maria L. Wilson"
Date:
Subject: Re: postgres 8.2.9 can't drop database in single user mode