Re: Problem with Large Object Interface of pgsql_perl5 - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: Problem with Large Object Interface of pgsql_perl5
Date
Msg-id 9673.954526278@sss.pgh.pa.us
Whole thread Raw
In response to Problem with Large Object Interface of pgsql_perl5  (Ken Causey <ken@premiernet.net>)
Responses Re: Problem with Large Object Interface of pgsql_perl5
List pgsql-interfaces
Ken Causey <ken@premiernet.net> writes:
> Can anyone tell me what I'm doing wrong?

Not doing the lo_open inside a transaction.  You need begin ... end
around any use of an open large object.  (This has always been true,
but older versions of Postgres didn't enforce it --- they'd just die
occasionally if you broke the rule.  Now, open LO handles are auto-
closed at transaction commit, which is to say at end of statement
if you're not inside a BEGIN block.)
        regards, tom lane


pgsql-interfaces by date:

Previous
From: Ken Causey
Date:
Subject: Problem with Large Object Interface of pgsql_perl5
Next
From: Ken Causey
Date:
Subject: Re: Problem with Large Object Interface of pgsql_perl5