deadlock while re-indexing table - Mailing list pgsql-general

reindex table user_profile;
ERROR:  deadlock detected
DETAIL:  Process 32450 waits for AccessExclusiveLock on relation
194689112 of database 163880909; blocked by process 31236.
Process 31236 waits for AccessShareLock on relation 194689110 of
database 163880909; blocked by process 32450.
jnj=# select * from pg_class  where oid = 194689112;
       relname      | relnamespace | reltype | relowner | relam |
relfilenode | reltablespace | relpages |  reltuples  | reltoastrelid |
reltoastidxid | relhasindex | relisshared | relkind | relnatts |
relchecks | reltriggers | relukeys | relfkeys | relrefs | relhasoids |
relhaspkey | relhasrules | relhassubclass | relfrozenxid | relacl |
reloptions
-------------------+--------------+---------+----------+-------
+-------------+---------------+----------+-------------+---------------
+---------------+-------------+-------------+---------+----------
+-----------+-------------+----------+----------+---------+------------
+------------+-------------+----------------+--------------+--------
+------------
  user_profile_pkey |         2200 |       0 |    16384 |   403 |
293905914 |             0 |     6004 | 2.18844e+06 |             0
|             0 | f           | f           | i       |        1
|         0 |           0 |        0 |        0 |       0 | f
| f          | f           | f              |            0 |        |
(1 row)

jnj=# select * from pg_class  where oid = 194689110;
         relname        | relnamespace | reltype | relowner | relam |
relfilenode | reltablespace | relpages |  reltuples  | reltoastrelid |
reltoastidxid | relhasindex | relisshared | relkind | relnatts |
relchecks | reltriggers | relukeys | relfkeys | relrefs | relhasoids |
relhaspkey | relhasrules | relhassubclass | relfrozenxid | relacl |
reloptions
-----------------------+--------------+---------+----------+-------
+-------------+---------------+----------+-------------+---------------
+---------------+-------------+-------------+---------+----------
+-----------+-------------+----------+----------+---------+------------
+------------+-------------+----------------+--------------+--------
+------------
  user_profile_name_key |         2200 |       0 |    16384 |   403
|   293905879 |             0 |     8746 | 2.18843e+06 |             0
|             0 | f           | f           | i       |        1
|         0 |           0 |        0 |        0 |       0 | f
| f          | f           | f              |            0 |        |

This is 100% repeatable ....

Dave