Thread: lo function changed in PostgreSQL 8.1.1
Dear All,
I use '$libdir/lo' for manage my Large Object for PostgreSQL 8.0.4 . Now I try to up my PostgreSQL to new version as 8.1.1 but I think I got some error about lo (Large Object).
lo (Large Object) function that normally shown in function list now disappear. I'm sure that I already check on Large Object box when I install. I found some information on http://www.postgresql.org/docs/8.1/interactive/lo-interfaces.html#AEN26978 about lo function. PostgreSQL has many new lo function that I never use in version 8.0.4 and some function I have use is not found (lo_in , lo_out).
Could you please advise me how to manage lo (Large Object) in PostgreSQL 8.1.1? (Normally I use VB6 as develop tool.)
And I'm not sure about my old lo (Large Object) data. How can I restore it for use in PostgreSQL 8.1.1?
Thank you
"Premsun Choltanwanich" <Premsun@nsasia.co.th> writes: > lo (Large Object) function that normally shown in function list now = > disappear. I'm sure that I already check on Large Object box when I = > install. I found some information on http://www.postgresql.org/docs/8.1/int= > eractive/lo-interfaces.html#AEN26978 about lo function. PostgreSQL has = > many new lo function that I never use in version 8.0.4 and some function I = > have use is not found (lo_in , lo_out). lo_in/lo_out aren't needed anymore because lo isn't a separate type, just a domain over OID. Why were you using them directly, anyway? regards, tom lane
Dear Tom,
I'm not sure that I understand your word correctly. But I will explain more information
I just need to keep my member's picture into database for showing and may have update sometime. I code my program with VB6. I found some suggestion to manage lo about lo_in and lo_out that why.
What thing I need to do for continue using lo on PostgreSQL 8.1.1
Ragards,
Premsun
>>> Tom Lane <tgl@sss.pgh.pa.us> 12/13/2005 22:39:11 >>>
"Premsun Choltanwanich" <Premsun@nsasia.co.th> writes:
> lo (Large Object) function that normally shown in function list now =
> disappear. I'm sure that I already check on Large Object box when I =
> install. I found some information on http://www.postgresql.org/docs/8.1/int=
> eractive/lo-interfaces.html#AEN26978 about lo function. PostgreSQL has =
> many new lo function that I never use in version 8.0.4 and some function I =
> have use is not found (lo_in , lo_out).
lo_in/lo_out aren't needed anymore because lo isn't a separate type,
just a domain over OID. Why were you using them directly, anyway?
regards, tom lane