> ~~~~~~~~~~~~~~~~~~~~~~
> Error: DBD::Pg::st execute failed: ERROR: deadlock detected at
> /usr/local/perlapache/lib/perl/Banner.pm line 71, <GEN1> line 7.
> ~~~~~~~~~~~~~~~~~~~~~~
It is a genuine error, occurs while two or more transaction process tries
to update/delete a same record simultaneously. You can overcome this by
locking the table in share row exclusive mode also. More details can be
found in the lock command documentation.
regards,
bhuvaneswaran