From: | "Purusothaman A" <purusothaman(dot)a(at)gmail(dot)com> |
---|---|
To: | "Richard Huxton" <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL. |
Date: | 2007-05-23 08:34:09 |
Message-ID: | 3650d0d50705230134n15b993aat8bbc631836eef65e@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Thanks Richard Huxton for your reply.
I use client side api for uploading and downloading files.
Its not happening immediately. But when database grows with data, file
object got corrupted.
My table structure is as follows.
Table "public.conf"
Column | Type | Modifiers
--------+------------------------+-----------
key | character varying(50) | not null
value | character varying(100) |
Indexes:
"conf_pkey" PRIMARY KEY, btree ("key")
Content of this table is,
key | value
---------------------+--------
HX | 101800
MASK | 101801
Rockey4ND | 101802
Threshold | 60
Authentication Mode | 2
(5 rows)
In the above, value of HX, MASK, Rockey4ND is 101800, 101801, 101802 (which
was returned by lo_import());
Actually for some peculiar reason I kept "Value" field as var char instead
of oid. (this could be reason?...)
This problem occurs only few weeks after uploading files.
Regards,
Purusothaman A
On 5/16/07, Richard Huxton <dev(at)archonet(dot)com> wrote:
>
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas | 2007-05-23 08:44:36 | Re: Can I restrict backups? |
Previous Message | Verna Vergara | 2007-05-23 06:33:34 | Question for linux drivers |
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2007-05-23 09:20:38 | Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL. |
Previous Message | Hannes Dorbath | 2007-05-23 08:13:08 | Re: partial word matching |