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

Re: perl and large objects

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
Cc: "pgsql-interfaces" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: perl and large objects
Date: 2005-05-19 10:05:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
On May 18, 2005, at 7:07 PM, Daniel Verite wrote:

> 	Sean Davis wrote:
>> I am new to large objects and have a simple test script that dies (at
>> the lo_import line) and I don't know why (no descriptive error given).
>> Any suggestions (or a quick tutorial)?  The DBD manual just wasn't
>> quite enough for me, I guess.
> The lack of error message feels like what happens when you call lo_*
> functions outside of a transaction. IIRC you just get 0 as the 
> resulting
> oid to a lo_import, for instance.
> You could try adding $dbh->do("select 1") just after 
> $dbh->{AutoCommit}=0
> to ensure that a transaction is started before the lo_import.
> Also, your code snippet runs fine for me, unmodified, with DBD::Pg 1.21
> Are you running an older version?


It was indeed that the transaction was not started.  Putting in a 
couple of "select 1" worked just fine.

Thanks for the help.


In response to

pgsql-interfaces by date

Next:From: Gustavo LopesDate: 2005-05-19 13:52:13
Subject: libpq on windows
Previous:From: Daniel VeriteDate: 2005-05-18 23:07:27
Subject: Re: perl and large objects

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