Thread: Re: How can I use large object on PostgreSQL Linux

Re: How can I use large object on PostgreSQL Linux

From
"Premsun Choltanwanich"
Date:
Thank You Michael Fuhr ,
 
Now, I already installed the contrib/lo and contrib/dbsize modules from source as your suggestion.
 
From my first information, I got 3 errors /lo, /dbsize and /admin. That mean now only  /admin that I cannot found anywhere.
 
I still try to find it. If anybody know more information about /admin (in Windows is admin.dll) please tell me.
 
 


>>> Michael Fuhr <mike@fuhr.org> 08-Feb-05 11:07:10 AM >>>
On Mon, Feb 07, 2005 at 02:33:24PM +0700, Premsun Choltanwanich wrote:

> > I'd guess that you haven't installed some third-party modules that
> > you need on the Linux box, or that you've installed them in the wrong
> > place.
>
> I don't make sure about third-party information cause all of module
> I use for Windows Version is install already on the time I install
> PostgreSQL RC1 on Windows.

If you built PostgreSQL from source then you can install the
contrib/lo and contrib/dbsize modules from source as well.  For
more information see contrib/README, contrib/lo/README.lo, and
contrib/dbsize/README.dbsize.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Re: How can I use large object on PostgreSQL Linux

From
Michael Fuhr
Date:
On Tue, Feb 08, 2005 at 02:55:01PM +0700, Premsun Choltanwanich wrote:

> From my first information, I got 3 errors /lo, /dbsize and /admin. That
> mean now only  /admin that I cannot found anywhere. 
>  
> I still try to find it. If anybody know more information about /admin
> (in Windows is admin.dll) please tell me.

I wonder if admin is pgadmin-tools.

http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin-tools/

What does the query below show on the Windows box?  If it shows the same
functions listed in pgadmin-tools/support/admin.sql.in then you might
need to install pgadmin-tools to make the systems identical (although
you might not actually need pgadmin-tools for its functionality).

SELECT proname, oidvectortypes(proargtypes) AS argtypes
FROM pg_proc
WHERE probin LIKE '%admin%';

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/