-----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-----
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
