From: Michael Neumann <uu9r@...>
Date: 2002-11-19T17:59:52+09:00
Subject: Re: [DBI] How to write BLOBs in a Postgres DB?

Stefan Scholl wrote:
> ts <decoux@moulon.inra.fr> wrote:
> >>>>>> "S" == Stefan Scholl <stefan.scholl@brave.de> writes:
> > 
> > S> Are there any (working) examples of writing a BLOB into a
> > S> Postgres db via DBI?
> > 
> > pigeon% b.rb
> > size : 4402656
> > ok
> > pigeon% 
> 
> 
> # ./b.rb
> size : 5750
> NOTICE:  ROLLBACK: no transaction in progress
> /usr/local/lib/ruby/site_ruby/1.6/DBD/Pg/Pg.rb:425:in `execute': can't open large object (DBI::ProgrammingError)
>         from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:1005:in `execute'
>         from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:1010:in `do'
>         from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:613:in `do'
>         from ./b.rb:9
>         from ./b.rb:4:in `connect'
>         from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:367:in `connect'
>         from ./b.rb:4
> 

Update to 0.0.18!

0.0.17 had problems with some Postgres databases regarding transaction handling.


Regards,

  Michael