Mario Weilguni <mweilguni@sime.com> writes:
> Since the type field is PK, there cannot be 2 rows with type='list', I guess
> the deadlock must have some different explanation.
Then the deadlock must involve rows in two different tables. What else
are you doing in the same transaction(s) as updating last_modified?
regards, tom lane