Re: Query regarding deadlock

Yogesh Sharma <Yogesh1.Sharma@nectechnologies.in> writes:
> ERROR:  deadlock detected
>  DETAIL:  Process 2234 waits for AccessShareLock on relation 16459 of database 16385; blocked by process 4111.
>  Process 4111 waits for ShareLock on relation 16502 of database 16385; blocked by process 2234.
>  Process 2234: INSERT INTO table1 ( id , unique_id )VALUES( '1', '4')
>  Process 4111: REINDEX TABLE table1

Offhand I would not expect those two commands to deadlock in isolation.
Are they parts of larger transactions that take additional locks?

            regards, tom lane