Thread: Restricting access to Large objects
I sent with the wrong email first. sorry. I can't find any docs / mails on this subject. How can I restrict access to large objects. 1.) Based on users. 2.) Rules/triggers? Thanx. Aasmund Midttun Godal aasmund@godal.com - http://www.godal.com/ +47 40 45 20 46 ---------- End Forwarded Message ---------- Aasmund Midttun Godal aasmund@godal.com - http://www.godal.com/ +47 40 45 20 46
"Aasmund Midttun Godal" <aasmund@godal.com> writes: > How can I restrict access to large objects. You can't. This is one of the many deficiencies of large objects. regards, tom lane
On Tue, 16 Oct 2001 03:46, Tom Lane wrote: > "Aasmund Midttun Godal" <aasmund@godal.com> writes: > > How can I restrict access to large objects. > > You can't. This is one of the many deficiencies of large objects. But now that the limit on row length / size has gone away, and that the new BYTEA type has appeared, it would seem that the need for large objects is redundant. Someone with more knowledge than I might like to comment.
Christopher Sawtell <csawtell@paradise.net.nz> writes: > On Tue, 16 Oct 2001 03:46, Tom Lane wrote: >> You can't. This is one of the many deficiencies of large objects. > But now that the limit on row length / size has gone away, and that the new > BYTEA type has appeared, it would seem that the need for large objects is > redundant. Someone with more knowledge than I might like to comment. Indeed, large objects are looking rather dinosaurian to me. TOASTed fields seem a far more natural and flexible way of dealing with large values. We still have some work to do on TOASTed fields --- for example, there's no API to read or write segments of a TOASTed field, as there is for large objects. And it'd be nice to be able to store or retrieve BYTEA values without worrying about quoting/escaping problems. But it makes a lot more sense to expend effort on fixing those issues than it does to expend effort on improving support for large objects. IMHO anyway. regards, tom lane