Re: foreign data wrappers

Excerpts from Zheng Yang's message of jue mar 24 05:49:19 -0300 2011:

> I am quite new to postgresql, but slowly picking up :)  In general context, storing images directly inside DBMS
fieldsas BLOBs was not considered as a good practice.  
> However, storing file directories  or links may cause inconsistency. So I am quite interested in how this datalink
conceptcan be implemented!  

I'm not really sure how different would be handling the file linking in
an FDW.  For example, if a transaction runs that deletes a file through
the FDW, and the transaction rolls back, how are you going to restore
the file to life?

(It sounds like you're trying to have a FDW that would present a
directory as a table, and each file in the dir as a row.  Maybe it's not
a bad idea but it needs a lot more thought.)

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support