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 |
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 |