Thread: cannot remove lock from HTAB
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, I'm not able to reproduce it anymore but I seen this after a deadlock detection involving a subtransaction: ERROR: deadlock detected DETAIL: Process 31330 waits for ShareLock on transaction 570; blocked by process 31328. Process 31328 waits for ShareLock on transaction 572; blocked by process 31330. regression=# abort; WARNING: cannot remove lock from HTAB ROLLBACK I don't have any HTAB around!! Basically this is what I did: begin; begin; update record 1; savepoint a; ~ update record 2; update record 2; ~ update record 1; ~ <dead lock detected> I hope that looking at the code is possible understand what the problem is ( if exists ). Regards Gaetano Mendola -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFBD8iS7UpzwH2SGd4RAgjxAJ9Gv2vkTjsdVaMSL2+b3yAcJlR5EgCgzwOD Owmr5zCfrhFE9eee0764p80= =jstJ -----END PGP SIGNATURE-----