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 !
=========================================================
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? |