| From: | Andrew Chernow <ac(at)esilo(dot)com> |
|---|---|
| To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
| Cc: | David Fetter <david(at)fetter(dot)org>, PG Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Extending varlena |
| Date: | 2008-08-18 23:28:38 |
| Message-ID: | 48AA05A6.3040702@esilo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Jeff Davis wrote:
>> I always find these requests puzzling. Is it really useful to store the
>> data for a jpeg, video file or a 10GB tar ball in a database column?
>
> One use case is that it can use the existing postgresql protocol,
>
>
So can what I am suggesting. How about a user-defined C function in the
backend that talks to the fs and uses SPI to sync info with a record?
Now the operation is behind a transaction. Yet, one must handle fs
orphans from evil crash cases.
Just one solution, but other more creative cats may have better ideas.
the point is, it can be done without too much effort. A little TLC :)
Andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-08-18 23:31:04 | Re: Extending varlena |
| Previous Message | Andrew Chernow | 2008-08-18 23:24:57 | Re: Extending varlena |