X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 948DB3A62F6; Fri, 10 Dec 2004 22:53:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10911-02; Fri, 10 Dec 2004 22:52:48 +0000 (GMT) Received: from sj-iport-5.cisco.com (sj-iport-5.cisco.com [171.68.10.87]) by svr1.postgresql.org (Postfix) with ESMTP id E63083A6CF9; Fri, 10 Dec 2004 19:52:17 +0000 (GMT) Received: from sj-core-3.cisco.com (171.68.223.137) by sj-iport-5.cisco.com with ESMTP; 10 Dec 2004 11:52:18 -0800 X-BrightmailFiltered: true X-Brightmail-Tracker: AAAAAA== Received: from cjwhitew2k02 (dhcp-128-107-147-121.cisco.com [128.107.147.121]) by sj-core-3.cisco.com (8.12.10/8.12.6) with ESMTP id iBAJq06n024238; Fri, 10 Dec 2004 11:52:02 -0800 (PST) Message-Id: <200412101952.iBAJq06n024238@sj-core-3.cisco.com> Reply-To: From: "Chris White (cjwhite)" To: , Subject: Issue with large objects Date: Fri, 10 Dec 2004 11:52:00 -0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0012_01C4DEAE.AA033830" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Thread-Index: AcTe8bZ5g1KcpoZ+SnuwWz9GDVNPlg== X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.402 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_60_70, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200412/68 X-Sequence-Number: 15654 This is a multi-part message in MIME format. ------=_NextPart_000_0012_01C4DEAE.AA033830 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I am putting a large object into my database using jdbc interface and using LargeObjectManager to do largeobject open, write and close. After several largeobject writes I get the following message 'failed to re-find parent-key in "pg_largeobject_loid_pn_index"' What does this mean and how do I resolve the issue? Do I need to re-index the largeobject table? Chris White ------=_NextPart_000_0012_01C4DEAE.AA033830 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
I am = putting a large=20 object into my database using jdbc interface and using = LargeObjectManager to do=20 largeobject open, write and close. After several largeobject writes = I get=20 the following message
 
'failed to re-find=20 parent-key in "pg_largeobject_loid_pn_index"'
 
What = does this mean=20 and how do I resolve the issue? Do I need to re-index the largeobject=20 table?
 
Chris=20 White
------=_NextPart_000_0012_01C4DEAE.AA033830--