deadlock on the same relation

Hi all,
I have a problem about deadlock. I have several stored procedures; only
one of them uses ACCESS EXCLUSIVE LOCK on a table; however, all the
stored procedures can access to that table, using SELECT, INSERT or UPDATE.
The stored procedures are called by different processes of an external
application.

In a non-predictable way, I obtain error messages like this one:

2005-11-29 18:23:06 [12771] ERROR:  deadlock detected
DETAIL:  Process 12771 waits for AccessExclusiveLock on relation 26052
of database 17142; blocked by process 12773.
        Process 12773 waits for AccessExclusiveLock on relation 26052 of
database 17142; blocked by process 12771.
CONTEXT:  PL/pgSQL function "set_session_box_status" line 7 at SQL statement

I don't understand what's happening; is it possible that a deadlock is
detected on the same relation (that is, the stored procedure using the
ACCESS EXCLUSIVE LOCK mentioned before) ?

I'm using Postgres 7.4.7 on a Debian Sarge.

Thanks!
Francesco


--

Francesco Formenti - TVBLOB S.r.l.
Software Engineer

 Via G. Paisiello, 9 20131 Milano, Italia
 -----------------------------------------
 Phone +39 02 36562440
 Fax +39 02 20408347
 Web Site http://www.tvblob.com
 E-mail francesco.formenti@tvblob.com