Itagaki Takahiro <itagaki.takah...@oss.ntt.co.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers