Обсуждение: Re: [INTERFACES] More about large objects

The postgresql docs, I posted the url didn't I?  Here it is again.

http://looking-glass.usask.ca/postgresql/docs/postgres/largeobjects.htm

And this is a quote from that page.

<QUOTE>
Originally, Postgres 4.2 supported three standard implementations of large
objects: as files external to Postgres, as UNIX files managed by Postgres,
and as data stored within the Postgres database. It causes considerable
confusion among users. As a result, we only support large objects as data
stored within the Postgres database in PostgreSQL.
</QUOTE>

So according to this, the large objects are stored in the table  But
from what I gather from the earlier large object talk, and from my
own observation, postgres uses external files.  Am I deluded?  Am I
missing something?

Gregory W Burnham
Software Engineer
Excite Labs
Faculty Of Education
Simon Fraser University
Vancouver, BC, V5A 1S6
604 291 3615 (ph)
604 291 5679 (fx)


----- Original Message -----
From: Thomas G. Lockhart <lockhart@alumni.caltech.edu>
To: Gregory W Burnham <gburnham@sfu.ca>
Cc: <pgsql-interfaces@postgreSQL.org>
Sent: Monday, February 01, 1999 9:31 PM
Subject: Re: [INTERFACES] More about large objects


>> Now I'm confused.  From what I'd gather from earlier today, Postgres
>> used external files.  Are the docs that out of date?
>
>Which docs? What were you gathering, and where??
>
>                     - Tom
>

> The postgresql docs, I posted the url didn't I?

Uh, yes. I'm familiar with that document, and it is accurate, at least
on that topic.

> So according to this, the large objects are stored in the table  But
> from what I gather from the earlier large object talk, and from my
> own observation, postgres uses external files.  Am I deluded?  Am I
> missing something?

Yes and yes again :)

The current large object implementation stores and accesses files within
the Postgres server. All access to the files happen through the standard
client-server connection.

Internally, Postgres stores all information in files, one file per
table, index, or large object. The large object files can be identified
with a file prefix of "xinv_" (I think; didn't check so it may be
something else) within the internal data storage directory
$(PGDATA)/base/dbname/

Hope this helps...

                     - Tom