From: Alvaro Herrera <alvherre@commandprompt.com>
To: Zheng Yang <zhengyang4k@gmail.com>
Cc: Guillaume Lelarge <guillaume@lelarge.info>
Cc: Selena Deckelmann <selena@chesnok.com>
Cc: Andrew Dunstan <andrew@dunslane.net>
Cc: pgsql-students <pgsql-students@postgresql.org>
Subject: Re: foreign data wrappers
Date: Thu, 24 Mar 2011 13:49:02 -0300
Message-ID: <1300985156-sup-3058@alvh.no-ip.org> (raw)
In-Reply-To: <4ACC318A-1B6F-49A5-9B02-49EEAF7B97C7@gmail.com>
References: <AANLkTi=FhaO5mX_YdqqsF1Yh0YNEHW8H1f0AUdpE0Fmo@mail.gmail.com>
<690867AB-C50B-4354-91D0-8A0811639C4C@gmail.com>
<AANLkTimKc4Jb4ydk=GO3shdv0gTPyad+y9z_kXXVKZoq@mail.gmail.com>
<4D879CD0.5030803@dunslane.net>
<AANLkTi=0KD_ef9XDJde52nb0n5YgysMHTjWwkKZurDR-@mail.gmail.com>
<3EF9E4CC-CF42-4B45-86FF-4CB9D46D7442@gmail.com>
<4D8AF8C2.3000007@lelarge.info>
<4ACC318A-1B6F-49A5-9B02-49EEAF7B97C7@gmail.com>
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 fields as 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 concept can 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: alvherre@commandprompt.com, zhengyang4k@gmail.com, guillaume@lelarge.info, selena@chesnok.com, andrew@dunslane.net, pgsql-students@postgresql.org
Subject: Re: foreign data wrappers
In-Reply-To: <1300985156-sup-3058@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox