Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL. - Mailing list pgsql-admin

From Richard Huxton
Subject Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL.
Date
Msg-id 464AD62B.9000003@archonet.com
Whole thread Raw
In response to OIDs - file objects, are damaged by PostgreSQL.  ("Purusothaman A" <purusothaman.a@gmail.com>)
Responses Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL.  ("Purusothaman A" <purusothaman.a@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Johann Spies
Date:
Subject: Re: ERROR: invalid memory alloc request size
Next
From: Joost Kraaijeveld
Date:
Subject: pg_dump not enough space to create a backup FreeBSD 6.1?