Re: Unanswered questions about Postgre

> 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