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