pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Wong Eric <hehe88hk@yahoo.com.hk>
To: L J Bayuk <ljb220@mindspring.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: create large object by tcl
Date: Sun, 22 Feb 2004 22:12:20 +0800 (CST)
Message-ID: <20040222141220.75395.qmail@web14908.mail.yahoo.com> (raw)
In-Reply-To: <200402211651.i1LGpFpL000747@mindspring.com>

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@mindspring.com> ªº¶l¥ó¤º®e¡G>
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. 

_________________________________________________________
¥²±þ§Þ¡B¶¼ºq¡B¤p¬P¬P...
®öº©¹aÁn  ±¡¤ß³sô
http://us.rd.yahoo.com/evt=22281/*http://ringtone.yahoo.com.hk/

view thread (3+ messages)  latest in thread

Message-ID: <20040222141220.75395.qmail@web14908.mail.yahoo.com>
Permalink:  ../20040222141220.75395.qmail@web14908.mail.yahoo.com/
Also on:    postgresql.org/message-id/20040222141220.75395.qmail@web14908.mail.yahoo.com

copy link · copy postgr.es

reply

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: hehe88hk@yahoo.com.hk, ljb220@mindspring.com
  Subject: Re: create large object by tcl
  In-Reply-To: <20040222141220.75395.qmail@web14908.mail.yahoo.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