"Vit Timchishin" <tivv@gtech-ua.com> writes:
> Can anyone tell me what are this "transaction" locks, when they are taken and why do I have a deadlock
> here.
Foreign-key update deadlock maybe? If so, updating to 8.1 is probably
a good solution. Previous versions took exclusive row locks on
referenced rows, and so you could easily get a deadlock on those row
locks.
regards, tom lane