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.