Received: from smtp4.mail.yahoo.com (smtp4.mail.yahoo.com [128.11.69.101]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0TJ4Qq23448 for ; Mon, 29 Jan 2001 14:04:26 -0500 (EST) (envelope-from janwieck@yahoo.com) Received: from j13.us.greatbridge.com (HELO jupiter.greatbridge.com) (216.54.52.153) by smtp.mail.vip.suc.yahoo.com with SMTP; 29 Jan 2001 19:04:24 -0000 X-Apparently-From: Received: (from janwieck@localhost) by jupiter.greatbridge.com (8.9.3/8.9.3) id OAA04385; Mon, 29 Jan 2001 14:14:41 -0500 From: Jan Wieck Message-Id: <200101291914.OAA04385@jupiter.greatbridge.com> Subject: Re: BLOB HOWTO?? In-Reply-To: from Olivier PRENANT at "Jan 29, 2001 12:17:02 pm" To: ohp@pyrenet.fr Date: Mon, 29 Jan 2001 14:14:41 -0500 (EST) CC: Bruce Momjian , pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/1313 X-Sequence-Number: 4078 Olivier PRENANT wrote: > Hi Bruce, > > Any idea when it's due for?? > I've been thining about writing a user function; But I'll get stuck with > permission as a user function is running under the "postgres" or whatever > user instead of the calling user. > > Also, what kind of binary interface are you thinking of?? Something similar to the existing lo_...() functions. Actually, someone should use the existing large objects to deal with binary content. What has to be kept in mind is 1. You have to cleanup yourself - the existing large objects aren't removed automatically if you delete a table row referencing to the LO or drop the table. 2. The existing LOs don't have copy behaviour. So if you reference to a LO from one table and do an INSERT ... SELECT, just it's OID is copied, not the data (as it should be IMHO). Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com