agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedLIBPQ large object interface
4+ messages / 2 participants
[nested] [flat]
* LIBPQ large object interface
@ 1994-09-12 01:52 Raj Vadakkencherry <raj@CS.UCLA.EDU>
0 siblings, 1 reply; 4+ messages in thread
From: Raj Vadakkencherry @ 1994-09-12 01:52 UTC (permalink / raw)
To: legacy
Hi,
I'm using the LIBPQ large object interface to creat (p_creat),
and write (p_write) to a large object as a Unix file.
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. What do I
need to do to make the file visible ?
Raj
==============================================================================
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.
==============================================================================
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: LIBPQ large object interface
@ 1994-09-12 04:22 Paul M. Aoki <aoki@cs.berkeley.edu>
parent: Raj Vadakkencherry <raj@CS.UCLA.EDU>
0 siblings, 0 replies; 4+ messages in thread
From: Paul M. Aoki @ 1994-09-12 04:22 UTC (permalink / raw)
To: Raj Vadakkencherry <raj@CS.UCLA.EDU>; +Cc: legacy
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.
==============================================================================
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: LIBPQ large object interface
@ 1994-09-12 18:11 Raj Vadakkencherry <raj@CS.UCLA.EDU>
0 siblings, 1 reply; 4+ messages in thread
From: Raj Vadakkencherry @ 1994-09-12 18:11 UTC (permalink / raw)
To: legacy
Hi,
As a related question (I'm using LIBPQ interface to large objects),
how can I delete a large object file that I create using p_creat and
p_write calls ?
You mention that the file is created with the name LOxxxxx and is located
in the database directory. But this directory is off limits for regular
users (ie., no read permission) and so the Large object file cannot be
deleted using regular unix commands.
Is there any way I can delete the file from within LIBPQ or otherwise ?
Raj.
> 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.
==============================================================================
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: LIBPQ large object interface
@ 1994-09-12 18:53 Paul M. Aoki <aoki@cs.berkeley.edu>
parent: Raj Vadakkencherry <raj@CS.UCLA.EDU>
0 siblings, 0 replies; 4+ messages in thread
From: Paul M. Aoki @ 1994-09-12 18:53 UTC (permalink / raw)
To: Raj Vadakkencherry <raj@CS.UCLA.EDU>; +Cc: legacy
raj@CS.UCLA.EDU (Raj Vadakkencherry) writes:
> how can I delete a large object file that I create using p_creat and
> p_write calls ?
there's a p_unlink call documented in the reference manual. this should
work for large objects of type Unix.
i don't think there's any way to unlink large objects of type Inversion
(e.g., those created by icopy) aside from prm/p_unlink'ing them and
then removing the Xinv???? class by hand.
--
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.
==============================================================================
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1994-09-12 18:53 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1994-09-12 01:52 LIBPQ large object interface Raj Vadakkencherry <raj@CS.UCLA.EDU>
1994-09-12 04:22 ` Paul M. Aoki <aoki@cs.berkeley.edu>
1994-09-12 18:11 Re: LIBPQ large object interface Raj Vadakkencherry <raj@CS.UCLA.EDU>
1994-09-12 18:53 ` Paul M. Aoki <aoki@cs.berkeley.edu>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox