On Wed, Jul 9, 2014 at 11:34 AM, M Tarkeshwar Rao <m.tarkeshwar....@ericsson.com> wrote: > > We analysed one more thing when we removed the unique index from the table it > is working fine. > Is there any issue in indexing? > > Is there any option to repair the table or its indexing?
REINDEX is useful for indexes. >From the sounds of it you had an uncommitted transaction that had inserted a conflicting id. If you were able to drop the index the other transaction had committed (or aborted) by that time. It's possible there was corruption but that doesn't usually lead to a hang and you haven't provided enough information to think that was the case. -- greg -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
