From: Richard Huxton <dev@archonet.com>
To: Purusothaman A <purusothaman.a@gmail.com>
Cc: pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL.
Date: Wed, 23 May 2007 10:20:38 +0100
Message-ID: <46540766.2030108@archonet.com> (raw)
In-Reply-To: <3650d0d50705230134n15b993aat8bbc631836eef65e@mail.gmail.com>
References: <3650d0d50705152242y689c0ef8u56223ec15661c821@mail.gmail.com>
<464AD62B.9000003@archonet.com>
<3650d0d50705230134n15b993aat8bbc631836eef65e@mail.gmail.com>
Purusothaman A wrote:
> 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.
Yes, but *HOW* - is it a different file, length is different, what?
> 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());
I find it unlikely that "2" and "60" were returned by lo_import() as
OIDs available for large-objects. You've either got:
1. Some other part of your application(s) overwriting "value"
2. Old data still in "value"
3. On-disk corruption due to crashes/hardware malfunction.
4. You're not showing real values
> Actually for some peculiar reason I kept "Value" field as var char instead
> of oid. (this could be reason?...)
Hmm - well it's clearly not right, but I don't see how it can cause
errors like this.
> This problem occurs only few weeks after uploading files.
You still haven't said precisely what the problem is.
--
Richard Huxton
Archonet Ltd
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: dev@archonet.com, purusothaman.a@gmail.com, pgsql-general@postgresql.org
Subject: Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL.
In-Reply-To: <46540766.2030108@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox