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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
