Re: BLOB HOWTO??

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(at)Yahoo(dot)com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com