Error: Using Large Objects by perl5-Interface - Mailing list pgsql-general

From Hans Reichenecker
Subject Error: Using Large Objects by perl5-Interface
Date
Msg-id NCBBLNMBEIIOPJJOMJEJOEBBDIAA.hr@woehr.de
Whole thread Raw
Responses Re: [GENERAL] Error: Using Large Objects by perl5-Interface  (<kaiq@realtyideas.com>)
List pgsql-general
I want to use Large Objects in PostgreSQL, source is a Perl-Script. But in
unchained mode it won´t work. What else should I do to change in chained
mode ?

    Users-Guide: "By default, Postgres executes transactions in
unchained mode (also known as "autocommit" in other database systems)."

Source:
      $result      = $conn->exec("BEGIN");
      $stoeroid    = $conn->lo_creat( 'PGRES_INV_ARCHIVE');
      $stoeroidlen = $conn->lo_write( $stoeroid, $Meldung, length(
$Meldung));
      $ERRor       = $conn->lo_close( $stoeroid);
      $result      = $conn->exec("END");

results in Debug-Backend
    query: BEGIN
    ProcessUtility: BEGIN
    CommitTransactionCommand
    StartTransactionCommand
    query: select proname, oid from pg_proc where proname = 'lo_open' or
proname = 'lo_close' or proname = 'lo_creat' or proname = 'lo_unlink'
    or proname = 'lo_lseek' or proname = 'lo_tell' or proname = 'loread'
or proname = 'lowrite'
    ProcessQuery
    CommitTransactionCommand
    StartTransactionCommand
    CommitTransactionCommand
    StartTransactionCommand
    ERROR:  lo_write: large obj descriptor (34850) out of range
    AbortCurrentTransaction
    StartTransactionCommand
    ERROR:  lo_close: large obj descriptor (34850) out of range
    AbortCurrentTransaction
    StartTransactionCommand
    query: END
    ProcessUtility: END
    CommitTransactionCommand

Thanks for help.

OTTO WÖHR GmbH         Tel: 07044 46-0
Hans Reichenecker      Tel: 07044 46193
Leiter DVO
Ölgrabenstraße 14      Fax: 07044 46266
71292 Friolzheim       http:www.woehr.de


Attachment

pgsql-general by date:

Previous
From: "V Krishnaraj"
Date:
Subject: Please help with these error messages
Next
From: "Dev Elop"
Date:
Subject: Re: [GENERAL] get the previous assigned sequence value