Thank you very much.
I use the following definition in my ODBC program.
create type lo (
Another question: If I "Drop type lo", does the lo
object exist yet?
--- 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
> 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 (
> The type is incomplete and hard to handle in
> 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
> 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.
> 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
> > clear the lo by myself? even to now? and how to
> > Haiquan Yang
> > __________________________________________________
> > Do You Yahoo!?
> > Buy the perfect holiday gifts at Yahoo! Shopping.
> > http://shopping.yahoo.com
> > ---------------------------(end of
> > TIP 4: Don't 'kill -9' the postmaster
Do You Yahoo!?
Send your FREE holiday greetings online!
In response to
pgsql-odbc by date
|Next:||From: Hiroshi Inoue||Date: 2001-12-11 02:09:13|
|Subject: Re: largeobject|
|Previous:||From: Dave Page||Date: 2001-12-10 19:46:13|
|Subject: Re: VB slow access|