Re: [HACKERS] Perl 5 Interface on 6.5 and lo_creat/lo_open problem - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Perl 5 Interface on 6.5 and lo_creat/lo_open problem
Date
Msg-id 22189.930181108@sss.pgh.pa.us
Whole thread Raw
In response to Perl 5 Interface on 6.5 and lo_creat/lo_open problem  (Kristofer Munn <kmunn@munn.com>)
Responses Re: [HACKERS] Perl 5 Interface on 6.5 and lo_creat/lo_open problem
Re: [HACKERS] Perl 5 Interface on 6.5 and lo_creat/lo_open problem
List pgsql-hackers
Kristofer Munn <kmunn@munn.com> writes:
> Is anyone else having any problems with the Perl Interface wrt Large
> Objects under 6.5?

> I compiled and installed 6.5 on an Intel/Linux/RedHat 6.0 machine that had
> previously had 6.4.2 and imported existing data from the old database.  
> Perl scripts which were working under the previous version are now failing
> when trying to open a newly created large object.  A line appears in the
> error log:

> Jun 23 17:40:47 www logger: ERROR:  lo_lseek: invalid large obj descriptor (0)

6.5 enforces the requirement that LO objects be used inside a
transaction.  Prior versions did not enforce this ... they just didn't
work very reliably if the lifetime of an LO FD wasn't encased in
begin/commit :-(.  I suppose you had managed to get away with it,
but you'd be much better off adding the begin/commit even for 6.4.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: [HACKERS] The dangers of "-F"
Next
From: Kristofer Munn
Date:
Subject: Re: [HACKERS] Perl 5 Interface on 6.5 and lo_creat/lo_open problem