Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> writes:
> I encountered the following log in 8.4.1 and HEAD. The deadlock occured
> on the same object (relation 17498 of database 17497). Is it reasonable?
I think this is an artifact of the fact that SQL functions parse the
whole querystring before executing any of it. Parsing of "DELETE FROM
a" will result in acquiring ROW EXCLUSIVE lock on a, and then when the
LOCK commands are executed, you have a lock-upgrade scenario and the
deadlock is unsurprising.
There was some discussion of changing that awhile ago, but I forget
what the conclusion was. In any case nothing's been done about it.
regards, tom lane