From: L J Bayuk <ljb220@mindspring.com>
To: hehe88hk@yahoo.com.hk
Cc: pgsql-interfaces@postgresql.org
Subject: Re: create large object by tcl
Date: Sat, 21 Feb 2004 11:51:15 -0500 (EST)
Message-ID: <200402211651.i1LGpFpL000747@mindspring.com> (raw)
In-Reply-To: <f2ccb7a1.0402200224.4945e447@posting.google.com>
hehe88hk@yahoo.com.hk wrote:
> ...
> If I use the libpgtcl library, I find it can only get a file
> descriptor of '-1' returned by pg_lo_open.
>
> If I use pgintcl, I find it can only get a file descriptor of '0'
> returned by pg_lo_open, followed by an error message:
>
> "
> ERROR: lo_write: invalid large obj descriptor (0)
> ...
Are you doing all your large object calls inside transaction blocks,
as required? If not, the large object descriptors will not be valid.
Send BEGIN, operate on a large object, then send COMMIT.
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: ljb220@mindspring.com, hehe88hk@yahoo.com.hk
Subject: Re: create large object by tcl
In-Reply-To: <200402211651.i1LGpFpL000747@mindspring.com>
* 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