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