Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 702A39FBC98; Wed, 16 May 2007 07:00:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 28827-02; Wed, 16 May 2007 07:00:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 581299FB766; Wed, 16 May 2007 07:00:16 -0300 (ADT) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 1DCFD74505; Wed, 16 May 2007 11:00:15 +0100 (BST) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 4F3B427411C; Wed, 16 May 2007 11:00:11 +0100 (BST) Message-ID: <464AD62B.9000003@archonet.com> Date: Wed, 16 May 2007 11:00:11 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 To: Purusothaman A Cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL. References: <3650d0d50705152242y689c0ef8u56223ec15661c821@mail.gmail.com> In-Reply-To: <3650d0d50705152242y689c0ef8u56223ec15661c821@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/138 X-Sequence-Number: 25458 Purusothaman A wrote: > Hi all, > > I am using Postgresql 8.2. 8.2.which? > I am using client side api to upload/download files to/from postgresql > using > calls lo_export()/lo_import(); > If I download a file from postgresql, few weeks later, files object's > contents got damaged. > > I don't know why. > > Do any of you have encountered same problem? It's not impossible that PostgreSQL is corrupting your large-objects, but it does seem unlikely. In what way were the large-object's contents corrupted? Was the file-length the same? Do you know exactly when it got corrupted? -- Richard Huxton Archonet Ltd