Re: PG 8.3.3 - ERROR: lock AccessShareLock on object 16385/16467/0 is already held

Michael Milligan <milli@acmeps.com> writes:
> Tom Lane wrote:
>> Huh, that shouldn't happen.  What object is that?  The 16385 should be
>> a database OID, and the 16467 is most likely a table's OID within that
>> database.

Please answer the above question.

> And a correction, the transaction that caused this error was inserting
> 13.5 million rows and failed near the end.

Once you've determined which table the error message is talking about,
please show us what the transaction does with that table.

            regards, tom lane