Error: Using Large Objects by perl5-Interface

From: "Hans Reichenecker" <hr(at)woehr(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Error: Using Large Objects by perl5-Interface
Date: 1999-12-09 11:51:59
Message-ID: NCBBLNMBEIIOPJJOMJEJOEBBDIAA.hr@woehr.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
winmail.dat application/ms-tnef 2.5 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stuart Rison 1999-12-09 12:49:24 Re: [GENERAL] get the previous assigned sequence value
Previous Message Dev Elop 1999-12-09 10:36:40 Re: [GENERAL] get the previous assigned sequence value