Re: [GENERAL] "LockRelease: locktable lookup failed, no lock" - Mailing list pgsql-general

From Steve Wolfe
Subject Re: [GENERAL] "LockRelease: locktable lookup failed, no lock"
Date
Msg-id 002601bf82ff$49b281d0$85755ad1@iboats.com
Whole thread Raw
In response to "LockRelease: locktable lookup failed, no lock"  ("Steve Wolfe" <steve@iboats.com>)
Responses Re: [GENERAL] "LockRelease: locktable lookup failed, no lock"  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-general
>   I'm getting "LockRelease: locktable lookup failed, no lock" trying to
> insert a row into a database.

  Well, I think I tracked down the problem - an index on a "text" field.
Once I removed the index, everything works well.  The odd thing is that not
*all* inserts would cause the error.  I suppose I ought to dig into the
docs when I get a few spare minutes...

steve


pgsql-general by date:

Previous
From: "Steve Wolfe"
Date:
Subject: "LockRelease: locktable lookup failed, no lock"
Next
From: Sandro Dentella
Date:
Subject: Re: CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP