Re: create large object by tcl - Mailing list pgsql-interfaces

From L J Bayuk
Subject Re: create large object by tcl
Date
Msg-id 200402211651.i1LGpFpL000747@mindspring.com
Whole thread Raw
Responses Re: create large object by tcl  (Wong Eric <hehe88hk@yahoo.com.hk>)
List pgsql-interfaces
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.


pgsql-interfaces by date:

Previous
From: L J Bayuk
Date:
Subject: (admin) Is mail/news gateway working for this list?
Next
From: Brett Schwarz
Date:
Subject: Re: tcl on gborg