Re: Foreign Tables - Mailing list pgsql-general
On Thu, Nov 17, 2011 at 2:59 AM, Raghavendra <raghavendra.rao@enterprisedb.com> wrote:
2011/11/17 Eliot Gable <egable+pgsql-general@gmail.com>:
<snip>> 1a) Can the foreign tables be written to? For example, I have server1 withForeign tables in 9.1 are read-only, so you can't write to them. Making
> table foo and server2 which does 'create foreign table bar' where bar
> references server1.foo. Can server2 write to bar and have it show in
> server1.foo?
foreign tables writable is a TODO item, but ISTM it's difficult to
implement it for even 9.2. So the answer to your question 1a) is "No".
BTW, I'm interested in your use case very much because I'm working on
enhancement of foreign tables for 9.2. I would appreciate it if you tell
me some details of your reporting system. Foreign tables may suit your
reporting system.
a) Where are materialized views, triggers and source tables? I guess all
of them are on appliances, not on PostgreSQL server for reporting.
b) Do you need to update data on appliances during making a report? If you
do, how do you do it without foreign tables? (from reporting application,
or using dblink or something?)
If source of report are on appliances as materialized views (or ordinary
tables), and you don't need to update data on appliances, I think you can
use foreign tables to gather information on a PostgreSQL server. In this
case, you need to define foreign tables for each materialized view (or
ordinary table). Then, you can execute SELECT statement using foreign
tables on the reporting server to gather information from appliances.
FDW for PostgreSQL 9.1, pgsql_fdw, is provided as a third party product[1],
though it seems not ready for production use.
# Currently you need to extract pgsql_fdw from git repository.
Incidentally, pgsql_fdw is being proposed as a contrib module of 9.2[2].
[1]https://sourceforge.net/projects/interdbconnect/
[2]http://archives.postgresql.org/pgsql-hackers/2011-10/msg01329.php
Regards,
--
Shigeru Hanada
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
This message is displayed because Gmail sees the 'from' address as being at gmail.com, but the SMTP headers show that it was actually sent from the mailing list server, so it reports that the message doesn't appear to be from who it says its from. On a technical level, its right, the message didn't come from Gmail and the mailing list software spoofed the from address.
-Adam
pgsql-general by date: