Re: largeobject

Hi, Inoue,

Thank you very much.
I use the following definition in my ODBC program.
create type lo (
internallength=4,
externallength=10,
input=int4in,
output=int4out,
default='',
passedbyvalue
);
Another question: If I "Drop type lo", does the lo
object exist yet?

Haiquan Yang

--- Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> wrote:
> "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

__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com