Re: [HACKERS] lo function changed in PostgreSQL 8.1.1

2005-12-19 Thread Premsun Choltanwanich
From contrib/lo I found that it has something  difference between old and new version of PostgreSQL.  And I'm sure that I already tick on Large Object (lo) option when I install.   How can I manage on difference function?       :::New Version::: DOMAIN lo AS pg_catalog.oid;   FUNCTION lo_oid(lo)

Re: [HACKERS] lo function changed in PostgreSQL 8.1.1

2005-12-14 Thread Premsun Choltanwanich
Thank you Tom. I will test it and reply the result as information for other. But it may a week for that cause many work in end of year.>>> Tom Lane <[EMAIL PROTECTED]> 12/14/2005 22:06:33 >>>"Premsun Choltanwanich" <[EMAIL PROTECTED]> writes:> I think I use contrib/lo type  for manage lo. What is

Re: [HACKERS] lo function changed in PostgreSQL 8.1.1

2005-12-14 Thread Tom Lane
"Premsun Choltanwanich" <[EMAIL PROTECTED]> writes: > I think I use contrib/lo type for manage lo. What is wrong? You need to use the 8.1 version of contrib/lo, not any previous version. You might find that the easiest way to manage this is to create an empty database, load the 8.1 contrib/lo de

Re: [HACKERS] lo function changed in PostgreSQL 8.1.1

2005-12-14 Thread Richard Huxton
Premsun Choltanwanich wrote: Dear Richard, I think I use contrib/lo type for manage lo. What is wrong? Now I have no idea for manage lo on PostgreSQL 8.1.1, I think I need a time to learn. Could you give me suggestion? Go back and check you have ticked the option in the installer. I don'

Re: [HACKERS] lo function changed in PostgreSQL 8.1.1

2005-12-13 Thread Premsun Choltanwanich
Dear Richard,   I think I use contrib/lo type  for manage lo. What is wrong?   Now I have no idea for manage lo on PostgreSQL 8.1.1, I think I need a time to learn.   Could you give me suggestion?   Regards,   Premsun   >>> Richard Huxton 12/13/2005 19:22:01 >>>Premsun Choltanwanich wrote:> Dear

Re: [HACKERS] lo function changed in PostgreSQL 8.1.1

2005-12-13 Thread Richard Huxton
Premsun Choltanwanich wrote: 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 disapp

[HACKERS] lo function changed in PostgreSQL 8.1.1

2005-12-13 Thread Premsun Choltanwanich
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 ch