Re: largeobject

"Henshall, Stuart - WCP" wrote:
>
> I believe in postgresql's contrib there's a program called vacuumlo

Unfortunately vacuumlo doesn't take type lo into account.

I changed vacuumlo so that it takes the type lo into
account in 7.2 but it doesn't handle the following
type created by
create type lo (
internallength=4,
externallength=10,
input=int4in,
output=int4out,
default='',
passedbyvalue
);

The type is incomplete and hard to handle in vacuumlo
or pg_restore. In 7.2 both vacuumlo and pg_restore
could handle the type lo defined in contrib/lo which
contains the definitions of input/output functions
etc.
Probably I had better recommend to use the type lo
in contrib/lo and change the documentation at http:
//odbc.postgresql.org/. However PostgreSQL hasn't
had a proper BLOB type yet and I don't know what
would occur about BLOB in the future.

regards,
Hiroshi Inoue

> Hope this helps,
> - Stuart
>
> -----Original Message-----
> From: odbc Postgres [mailto:psqlodbc(at)yahoo(dot)com]
> Sent: 05 December 2001 07:59
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: largeobject
>
> Hi, everyone,
>
> From http://odbc.postgresql.org , I looked the
> following
>
> >Another important note is that this new type is
> > lacking in functionality.
> >It will not cleanup after itself on updates
> >and deletes, thus leaving orphans
> >around and using up extra disk space.
> >And currently, Postgres does not
> > support the vacuuming of large objects.
>
> I want to use largeobject, Does this means I must
> clear the lo by myself? even to now? and how to do?
>
> Haiquan Yang
>
> __________________________________________________
> Do You Yahoo!?
> Buy the perfect holiday gifts at Yahoo! Shopping.
> http://shopping.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster