Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 20F412E002E for ; Tue, 10 Jun 2008 17:37:39 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 87302-06 for ; Tue, 10 Jun 2008 17:37:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mailrelay.embarq.synacor.com (mailrelay.embarq.synacor.com [208.47.184.3]) by developer.postgresql.org (Postfix) with ESMTP id B31D12E0031 for ; Tue, 10 Jun 2008 17:37:32 -0300 (ADT) DKIM-Signature: v=1; a=rsa-sha1; d=embarqmail.com; s=s012408; c=relaxed/simple; q=dns/txt; i=@embarqmail.com; t=1213130251; h=From:Subject:Date:To:Mime-Version:Content-Type; bh=oJnhE6gfrkW92/tuIhFSXowjWQM=; b=oXVrYsepR4+yATnlyEJlu6Stx2ScQDPW0GnX5KAwXDBc6SU+2t6li7uZ11+3UdAX +dCEbmMvP3+MQ7H7AKJCVR/WR1UpL8zOtugdFUCUhhp4PIR1aY6CcDfpBXPcak4e; X_CMAE_Category: 0,0 Undefined,Undefined X-CNFS-Analysis: v=1.0 c=1 a=yojgaC0HzEAA:10 a=gra_WR_tcWEA:10 a=VlR1BT0uigBWQ1q1wzYA:9 a=XAzCCty75es9WJUpOt1VDPXHIZIA:4 a=cvn8laQl214A:10 a=LY0hPdMaydYA:10 X-CM-Score: 0 X-Scanned-by: Cloudmark Authority Engine Authentication-Results: smtp09.embarq.synacor.com smtp.user=amsden_linux@embarqmail.com; auth=pass (LOGIN) Received: from [71.2.202.190] ([71.2.202.190:45924] helo=[192.168.0.30]) by mailrelay.embarq.synacor.com (envelope-from ) (ecelerity 2.2.1.28 r(22594)) with ESMTPA id F9/20-08696-A06EE484; Tue, 10 Jun 2008 16:37:31 -0400 Subject: Re: pqlib large object error From: Edward Amsden To: pgsql-interfaces@postgresql.org In-Reply-To: <21991.1213122593@sss.pgh.pa.us> References: <1213118594.9123.11.camel@dad-desktop2> <21991.1213122593@sss.pgh.pa.us> Content-Type: text/plain Date: Tue, 10 Jun 2008 16:37:22 -0400 Message-Id: <1213130242.15557.3.camel@dad-desktop2> Mime-Version: 1.0 X-Mailer: Evolution 2.22.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/3 X-Sequence-Number: 6746 On Tue, 2008-06-10 at 14:29 -0400, Tom Lane wrote: > Edward Amsden writes: > > I cannot seem to figure this error message out: > > > ERROR: duplicate key value violates unique constraint "pg_largeobject_loid_pn_index" > > Huh, that shouldn't happen. Is it repeatable? Yes. It happens every time the program runs, no matter what db or user, tried unix socket and tcp connect > What PG version > is your server? 8.3.1, running on Ubuntu Linux > > regards, tom lane