Error: Using Large Objects by perl5-Interface
От | Hans Reichenecker |
---|---|
Тема | Error: Using Large Objects by perl5-Interface |
Дата | |
Msg-id | NCBBLNMBEIIOPJJOMJEJOEBBDIAA.hr@woehr.de обсуждение исходный текст |
Ответы |
Re: [GENERAL] Error: Using Large Objects by perl5-Interface
|
Список | 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
Вложения
В списке pgsql-general по дате отправления: