Skip site navigation (1) Skip section navigation (2)

Re: largeobject

From: odbc Postgres <psqlodbc(at)yahoo(dot)com>
To: Inoue(at)tpf(dot)co(dot)jp
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: largeobject
Date: 2001-12-11 00:05:19
Message-ID: 20011211000519.76331.qmail@web21007.mail.yahoo.com (view raw or flat)
Thread:
Lists: 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(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

In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-12-11 02:09:13
Subject: Re: largeobject
Previous:From: Dave PageDate: 2001-12-10 19:46:13
Subject: Re: VB slow access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group