From: | <kaiq(at)realtyideas(dot)com> |
---|---|
To: | Hans(dot)Reichenecker(at)woehr(dot)de |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Error: Using Large Objects by perl5-Interface |
Date: | 1999-12-09 16:44:32 |
Message-ID: | Pine.LNX.4.10.9912091040260.27698-100000@picasso.realtyideas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
in your perl script:
$dbh->{AutoCommit}=0;
you can get more info by perldoc DBI and perldoc DBD::Pg
On Thu, 9 Dec 1999, Hans Reichenecker wrote:
> I want to use Large Objects in PostgreSQL, source is a Perl-Script. But in
> unchained mode it wont 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 WHR GmbH Tel: 07044 46-0
> Hans Reichenecker Tel: 07044 46193
> Leiter DVO
> lgrabenstrae 14 Fax: 07044 46266
> 71292 Friolzheim http:www.woehr.de
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | soundar rajan | 1999-12-09 16:49:08 | JDBC2.0 and pg |
Previous Message | Ross J. Reedstrom | 1999-12-09 16:35:32 | Re: [GENERAL] get the previous assigned sequence value |