On 4/19/15 9:53 PM, Tim Uckun wrote:

On Sat, Apr 18, 2015 at 10:24 AM, Pawel Veselov <pawel.vese...@gmail.com
<mailto:pawel.vese...@gmail.com>> wrote:

    I found some dangling prepared transactions



How do you find and remove these?

SELECT * FROM pg_prepared_xacts;
ROLLBACK PREPARED xid;
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to