Dmitry Koterov wrote: >> Have you checked for prepared transactions in that DB? See >> pg_prepared_xacts view (I've been burnt by that myself...) > > 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... The command is: ROLLBACK PREPARED 'yourgid' 'DEALLOCATE' is for prepared statements. Yours, Laurenz Albe
