Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL.

From: Richard Huxton <dev(at)archonet(dot)com>
To: Purusothaman A <purusothaman(dot)a(at)gmail(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 09:20:38
Message-ID: 46540766.2030108@archonet.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
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

In response to

Responses

pgsql-admin by date

Next:From: Vishal AroraDate: 2007-05-23 09:34:07
Subject: Re: initializing the DB cluster
Previous:From: Mondi RaviDate: 2007-05-23 08:53:58
Subject: how to view all database,tables,users

pgsql-general by date

Next:From: L. BergerDate: 2007-05-23 10:40:30
Subject: Re: SQL Manager 2007 for PostgreSQL released
Previous:From: Purusothaman ADate: 2007-05-23 08:34:09
Subject: Re: [GENERAL] OIDs - file objects, are damaged by PostgreSQL.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group