Re: Supporting SQL/MED DATALINK - Mailing list pgsql-general

From Neil Tiffin
Subject Re: Supporting SQL/MED DATALINK
Date
Msg-id 22CE0164-6870-4D1B-B9F6-244E3F58B328@neiltiffin.com
Whole thread Raw
In response to Re: Supporting SQL/MED DATALINK  (Alban Hertroys <haramrae@gmail.com>)
List pgsql-general
On Jan 9, 2012, at 5:07 AM, Alban Hertroys wrote:

> On 9 January 2012 09:56, Damiano ALBANI
>>> I believe DB2 is pretty much it in this area.
>>
>> For the record, it looks like MS SQL Server has some equivalent feature :
>> FILESTREAM.
>
> And Oracle has BFILE.
>
> I've actually been thinking about how to implement something like this
> for Postgres, but the interaction with the file-system makes it a
> little more difficult to implement. Someone shouldn't be able to
> delete a file from the file-system that's still referenced from the
> database.
> Perhaps a file-system layer with FusionFS would be a suitable solution
> for something like this, but I couldn't convince myself that it is.
>
> In the end, it probably requires a custom file-system implementation
> that needs maintaining across all operating systems that Postgres runs
> on. That's a major undertaking!
> --
> If you can't see the forest for the trees,
> Cut the trees and you'll see there is no forest.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Not sure I see the need to keep the user/system from deleting a database referenced file.  BFILEs are created
completelyoutside of Oracle and Oracle will not insert data or write to a BFILE.  It seems the reference to the
externalfile is a very weak read only reference as BFILE provides functions like fileExists() and isFileOpen().  They
leaveit up to the code to determine if the file is available and has the correct permisisons. 

pgsql-general by date:

Previous
From: ChoonSoo Park
Date:
Subject: Re: How to code lo_creat & lo_write & lo_read in non-blocking mode
Next
From: Alban Hertroys
Date:
Subject: Re: Binary Large Objects (LOB/BLOB) in Hibernate and JDBC: Unresolved issues