Yogesh Sharma <Yogesh1.Sharma@xxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
