agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: Paul M. Aoki <aoki@cs.berkeley.edu>
To: Raj Vadakkencherry <raj@CS.UCLA.EDU>
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: LIBPQ large object interface
Date: Sun, 11 Sep 94 21:22:08 -0700
Message-ID: <199409120422.VAA14858@faerie.CS.Berkeley.EDU> (raw)
In-Reply-To: <9409120152.AA22120@oahu.cs.ucla.edu>
raj@CS.UCLA.EDU (Raj Vadakkencherry) writes:
> When I'm done writing, I issue a p_close command and exit successfully,
> but the file is not visible in the Unix file system.
the file will not be visible with the same name you give it. the
/-delimited path is only useful within the virtual inversion file
system. instead, it will have the name LOxxxxxx where xxxxxx is the
object id of the tuple in pg_naming that corresponds to the file name.
this file is located in the database directory.
if you want to use files that are visible within the regular unix name
space, you must use the external large object interface. this is
turned off in the distribution for security reasons; see the LARGE
OBJECT ref manual page.
--
Paul M. Aoki | University of California at Berkeley
aoki@CS.Berkeley.EDU | Dept. of EECS, Computer Science Division (#1776)
| Berkeley, CA 94720-1776
==============================================================================
To add/remove yourself to/from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
==============================================================================
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: postgres@postgres.berkeley.edu
Cc: aoki@cs.berkeley.edu, raj@CS.UCLA.EDU
Subject: Re: LIBPQ large object interface
In-Reply-To: <199409120422.VAA14858@faerie.CS.Berkeley.EDU>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox