pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedlo function changed in PostgreSQL 8.1.1
3+ messages / 2 participants
[nested] [flat]
* lo function changed in PostgreSQL 8.1.1
@ 2005-12-13 08:54 Premsun Choltanwanich <Premsun@nsasia.co.th>
2005-12-13 15:39 ` Re: lo function changed in PostgreSQL 8.1.1 Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Premsun Choltanwanich @ 2005-12-13 08:54 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: lo function changed in PostgreSQL 8.1.1
2005-12-13 08:54 lo function changed in PostgreSQL 8.1.1 Premsun Choltanwanich <Premsun@nsasia.co.th>
@ 2005-12-13 15:39 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-12-14 03:56 ` Re: lo function changed in PostgreSQL 8.1.1 Premsun Choltanwanich <Premsun@nsasia.co.th>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2005-12-13 15:39 UTC (permalink / raw)
To: Premsun Choltanwanich <Premsun@nsasia.co.th>; +Cc: pgsql-sql
"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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: lo function changed in PostgreSQL 8.1.1
2005-12-13 08:54 lo function changed in PostgreSQL 8.1.1 Premsun Choltanwanich <Premsun@nsasia.co.th>
2005-12-13 15:39 ` Re: lo function changed in PostgreSQL 8.1.1 Tom Lane <tgl@sss.pgh.pa.us>
@ 2005-12-14 03:56 ` Premsun Choltanwanich <Premsun@nsasia.co.th>
0 siblings, 0 replies; 3+ messages in thread
From: Premsun Choltanwanich @ 2005-12-14 03:56 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-12-14 03:56 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-13 08:54 lo function changed in PostgreSQL 8.1.1 Premsun Choltanwanich <Premsun@nsasia.co.th>
2005-12-13 15:39 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-12-14 03:56 ` Premsun Choltanwanich <Premsun@nsasia.co.th>
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