From: | Jan Wieck <janwieck(at)Yahoo(dot)com> |
---|---|
To: | ohp(at)pyrenet(dot)fr |
Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: BLOB HOWTO?? |
Date: | 2001-01-29 19:14:41 |
Message-ID: | 200101291914.OAA04385@jupiter.greatbridge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | dom | 2001-01-29 19:25:36 | Re: Ungraceful handling of fatal flex errors |
Previous Message | KuroiNeko | 2001-01-29 18:41:27 | Re: Security hole in PL/pgSQL |
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2001-01-29 19:33:13 | Re: Emergency case: Postgres problems |
Previous Message | Jan Wieck | 2001-01-29 19:08:16 | Re: |