Postgresql + lo

From: Florian Baumert <baumert(at)plt(dot)de>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Postgresql + lo
Date: 1999-07-08 22:19:51
Message-ID: 1913.990709@plt.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hi there,

I have a major problem with postgresql 6.5. In my database, I've
created the lo-type, as explained in the FAQ. I have a table which
uses this type. If i want to acces it with (eg) perl
use Pg; $conn = Pg::connectdb("dbname=test");$lobj_fd = $conn->lo_open(33025, PGRES_INV_WRITE|PGRES_INV_READ); print $lobj_fd;
The xinv33025 exists and the oid 33025 was created by a call to lo_create.

What happens is that it writes a -1 to the screen and a database-error "ERROR: lo_lseek: invalid large obj descriptor (0)"
The same happens, if I use php3 (compiled against postgresql) and the
ODBC-driver for windoes (06.40.0006). If i compile and start
examples/test/lotest.c (hope, it's the right name) in the
posrgresql-src directory, it works!!!

If I comment out the call to lo_lseek in lo_open, it works further,
but then I get problems in lo_close (same error as above, only in
lo_close).

What happens here?

Thanx in advance

Florian

\\|||//
| |
(.) (.)
===================oOO==(_)==OOo=========================
! Florian Baumert !
? Birkenweg 2 ?
! D-61267 Neu-Anspach ?
! Tel.:06081-9 63 63 7 !
? ===================================================== ?
! baumert(at)plt(dot)de www.plt.de !
=========================================================

Browse pgsql-interfaces by date

  From Date Subject
Next Message Geoffrey C. Speicher 1999-07-08 22:25:13 Re: [INTERFACES] libpq AND C++ Builder
Previous Message George Young 1999-07-08 19:55:59 transactions in libpq++ require new connection?