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: | 4dc77e1fc370855bf943a592b665e88c@mail.nih.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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?
>
DBD::Pg-1.41
It was indeed that the transaction was not started. Putting in a
couple of "select 1" worked just fine.
Thanks for the help.
Sean
From | Date | Subject | |
---|---|---|---|
Next Message | Gustavo Lopes | 2005-05-19 13:52:13 | libpq on windows |
Previous Message | Daniel Verite | 2005-05-18 23:07:27 | Re: perl and large objects |