Phoenix Kiula <phoenix.kiula@xxxxxxxxx> writes: > How can I get rid of these open locks? Close the transactions that are holding them. Look into pg_stat_activity and pg_prepared_xacts. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general