Re: deadlock problem in Ad serving..

> ~~~~~~~~~~~~~~~~~~~~~~
> 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