From: Stefan Scholl <stefan.scholl@...>
Date: 2002-11-19T17:48:53+09:00
Subject: Re: [DBI] How to write BLOBs in a Postgres DB?

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