Re: largeobject - Mailing list pgsql-odbc

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@tpf.co.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@yahoo.com]
> > Sent: 05 December 2001 07:59
> > To: pgsql-odbc@postgresql.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