Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id VAA19281 for postgres-redist; Sun, 11 Sep 1994 21:22:17 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199409120422.VAA19281@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.37.53]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with ESMTP id VAA19271 for <postgres@postgres.Berkeley.EDU>; Sun, 11 Sep 1994 21:22:17 -0700
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.9/8.1B) with SMTP id VAA14858; Sun, 11 Sep 1994 21:22:14 -0700
Message-Id: <199409120422.VAA14858@faerie.CS.Berkeley.EDU>
X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
From: aoki@cs.berkeley.edu (Paul M. Aoki)
To: raj@CS.UCLA.EDU (Raj Vadakkencherry)
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: LIBPQ large object interface 
Reply-To: aoki@cs.berkeley.edu (Paul M. Aoki)
In-reply-to: Your message of Sun, 11 Sep 1994 18:52:06 -0700 (PDT) 
	     <9409120152.AA22120@oahu.cs.ucla.edu> 
Date: Sun, 11 Sep 94 21:22:08 -0700
X-Sender: aoki@postgres.Berkeley.EDU
Resent-To: postgres-redist@postgres.Berkeley.EDU
X-Mts: smtp
Resent-Date: Sun, 11 Sep 94 21:22:17 -0700
Resent-XMts: smtp

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.
==============================================================================