Hello,
Is it 'lo_unlink' a secure function?.
I've problems with it. I'm using a database with large objects (images) and
I've problems
with that, this problems are:
* Sometimes, when I tried to export a large object with SQL command:
SELECT lo_export(oid '65570', '/tmp/myfile')
the backend says to me:
ERROR: xinx65560 is a index relation.
I see that the oids of 'xinv65570' and 'xinx65560' are the same. So, when I
say to postgres that I want to export the oid 65570, it thinks that I want
the index xinx65560.
I fix this problem using the function 'heap_openr' in 'inv_open' instead of
'heap_open'. With this change, I always open a 'xinvXXXX'. I've made this
change in 'inv_destroy', too.
* The other problem is related the function 'lo_unlink'. I think that when I
destroy a large object, I destroy its index, then, if I do:
SELECT lo_unlink( int4 '65560')
I'm sure that I destroy the object 'xinv65560' (because I've changed the
'heap_open' by 'heap_openr'), and if the backend attempts to destroy the
index (whose oid is 65570), and as it's the same oid that the large object
'xinv65570' , it's possible the backend destroy that large object instead of
the index.
Well, my questions are:
* Is this true?, Is it like I think?.
* Are there some solutions for these problems?
Thanks.
(Please answer to me at: carlos@nernet.unex.es)
Carlos J. Garcia Orellana.
Universidad de Extramadura - Badajoz
SPAIN