Re: Unanswered questions about Postgre

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: kislo@athenium.com, Joel Burton <jburton@scw.org>, igorr@ifi.uio.no, pgsql-general@postgresql.org
Date: 2000-12-12T02:03:45Z
Lists: pgsql-general
> This is a misunderstanding.  You can still use the old-style large
> objects (in fact 7.1 has an improved implementation of them too),
> and there's always been support for either over-the-wire or
> server-filesystem read and write of large objects.  In fact the former
> is the preferred way; the latter is deprecated because of security
> issues.  In a standard installation you can't do the server-filesystem
> bit at all unless you are superuser.

I know we haven't talked about the TOAST/binary interface, but one idea
I had was to load the binary into the large object interface, then
automatically somehow transfer it to the TOAST column.  Same for
extracting large objects.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026