From: Florian Baumert <baumert@plt.de>
To: pgsql-interfaces@postgresql.org
Subject: Postgresql + lo
Date: Fri, 9 Jul 1999 00:19:51 +0200
Message-ID: <1913.990709@plt.de> (raw)
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@plt.de www.plt.de !
=========================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: baumert@plt.de
Subject: Re: Postgresql + lo
In-Reply-To: <1913.990709@plt.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox