Skip site navigation (1) Skip section navigation (2)

Re: create large object by tcl

From: Wong Eric <hehe88hk(at)yahoo(dot)com(dot)hk>
To: L J Bayuk <ljb220(at)mindspring(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: create large object by tcl
Date: 2004-02-22 14:12:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
Thanks for your help and I can create and write to
large object by Tcl successfully.

(I find that the documentation has mentioned about
this and I overlooked it)

However, I would like to ask why a transaction is
needed for accessing large object?

 --- L J Bayuk <ljb220(at)mindspring(dot)com> 的郵件內容:>
hehe88hk(at)yahoo(dot)com(dot)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

浪漫鈴聲  情心連繫*

In response to


pgsql-interfaces by date

Next:From: Cornelia BoenigkDate: 2004-02-22 16:50:55
Subject: problem with cursur within a scriptfile
Previous:From: gregDate: 2004-02-22 12:33:34
Subject: DBD::Pg 1.32 ready for testing

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group