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

Michael Neumann <uu9r@rz.uni-karlsruhe.de> wrote:
> 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)

> Update to 0.0.18!
> 0.0.17 had problems with some Postgres databases regarding transaction handling.

This isn't mentioned in the Changelog.


OK, thanks. The test code works with 0.0.18. And after adding
transaction it remembers the BLOB after the connection is closed.